43
7/23/2019 Atp Examples http://slidepdf.com/reader/full/atp-examples 1/43 298606214.xlsx Page 1 Low Medium High Control 34 41 32 43 36 42 56 42 42 38 53 41 51 53 28 37 38 43 43 50 32 35 54 26 36 37 52 33

Atp Examples

  • Upload
    pvenky

  • View
    218

  • Download
    0

Embed Size (px)

Citation preview

Page 1: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 1/43

298606214.xlsx

Page 1

Low Medium High Control

34 41 32 43

36 42 56 42

42 38 53 41

51 53 28 37

38 43 43 50

32 35 54 26

36 37 52 33

Page 2: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 2/43

298606214.xlsx

Page 2

Anova: Single Factor

SUA!"

Groups Count Sum Average Variance

#o$ 7 269 38.42857 40.61905

e%i&' 7 289 41.28571 34.90476

(ig) 7 318 45.42857 129.2857

*ontrol 7 272 38.85714 59.80952

A+,-A

Source of Variation SS df MS F P-value F crit  

et$een /ro&s 216.2857 3 72.09524 1.089797 0.372433 3.008787

it)in /ro&s 1587.714 24 66.15476

 otal 1804 27

Page 3: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 3/43

298606214.xlsx

Page 3

Name Height Weight Sex Test1 Test2 Test3 Test4

Bill   74.2 176 1 90 86 134 65

Mike   68.5 132 1 90 87 122 31

Carol   65.0 157 0 82 75 145 2

Scott   73.2 199 1 90 79 109 7

Jill   65.8 154 0 100 92 132 79

Francis   52.4 101 0 78 89 176 18

Helen   69.2 157 0 90 84 103 64

Marci   69.0 148 0 65 54 123 100

Benedict   77.0 225 1 92 85 132 74

Hank   71.0 179 1 70 60 144 36

John   73.5 190 1 69 58 156 12

Susan   66.9 155 0 80 86 157 68

Gloria   67.1 190 0 89 77 98 23

Height Weight Sex Test1 Test2 Test3 Test4

(eig)t 1.0000eig)t 0.8403 1.0000

Sex 0.6708 0.5189 1.0000

 est1 0.0996 0.1635 0.0035 1.0000

 est2 0.2805 0.2244 0.1533 0.8365 1.0000

 est3 0.4374 0.3845 0.0136 0.4450 0.0203 1.0000

 est4 0.2272 0.0036 0.2127 0.0784 0.0673 0.1515 1.0000

 est5 0.1016 0.1777 0.0452 0.2894 0.2099 0.3746 0.0127

 )is tec)ni&e &sesor'&las rat)er t)an t)e

Analsis oolPa.

Page 4: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 4/43

298606214.xlsx

Page 4

Test5 Height Weight Sex est! est"

9   (eig)t 1.0000

67   eig)t 0.8403 1.0000

6   Sex 0.6708 0.5189 1.0000

92   est1 0.0996 0.1635 0.0035 1.0000

73   est2 0.2805 0.2244 0.1533 0.8365 1.0000

50   est3 0.4374 0.3845 0.0136 0.4450 0.0203

87   est4 0.2272 0.0036 0.2127 0.0784 0.0673

32   est5 0.1016 0.1777 0.0452 0.2894 0.2099

22

78

1

22

25

Test5

1.0000

Page 5: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 5/43

298606214.xlsx

Page 5

est# est$ est%

1.0000

0.1515 1.0000

0.3746 0.0127 1.0000

Page 6: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 6/43

*ovariance

Page 6

Name Test1 Test2 Test3 Test4 Test5

Bill   1 1 134 65 9   est1

Mike   2 2 122 31 67   est2

Carol   3 3 145 2 6   est3

Scott   4 4 109 7 92   est4

Jill   5 5 132 79 73   est5

Francis   6 6 176 18 50

Helen   7 7 103 64 87

Marci   8 8 123 100 32

Benedict   9 9 132 74 22

Hank   10 10 144 36 78

John   11 11 156 12 1

Susan   12 12 157 68 22

Gloria   13 13 98 23 25

Test1 Test2 Test3 Test4 Test5

 est1 14.0000 est2 14.0000 14.0000

 est3 4.2308 4.2308 472.5917

 est4 10.5722 10.5722 100.8166 937.5172

 est5 23.9176 23.9176 253.7264 12.0757 970.6370

 )is tec)ni&e &sesor'&las rat)er t)an t)e

Analsis oolPa.

Page 7: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 7/43

*ovariance

Page 7

est! est" est# est$ est%

14.0000

14.0000 14.0000

4.2308 4.2308 472.5917

10.5722 10.5722 100.8166 937.5172

23.9176 23.9176 253.7264 12.0757 970.6370

Page 8: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 8/43

298606214.xlsx

Page 8

W& Coast Sample

35 41 52

32 35 29 ean 39.25

46 36 43 Stan%ar% rror 1.848007

57 45 45 e%ian 37.5

45 44 28 o%e 37

28 62 35 Stan%ar% eviation 8.264541

60 61 37 Sa'le -ariance 68.30263

37 62 32 &rtosis 1.472661

34 36 37 Se$ness 1.180114

33 52 41 !ange 32

37 46 54 ini'&' 28

32 52 44 axi'&' 60

38 38 42 S&' 785

41 28 48 *o&nt 20

38 50 46 3.867925

42 52 47

29 48 39

40 38 40

37 44 41

44 50 47

W. CoastSamle

MidwestSamle

!. CoastSamle

*on;%ence#evel<95.0=>

Page 9: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 9/43

298606214.xlsx

Page 9

Mid'est Sample (& Coast Sample

ean 46 ean 41.35

Stan%ar% rror 2.10763 Stan%ar% rror 1.564869

e%ian 45.5 e%ian 41.5

o%e 52 o%e 37

Stan%ar% eviation 9.425609 Stan%ar% eviation 6.998308

Sa'le -ariance 88.84211Sa'le -ariance 48.97632

&rtosis 0.47699 &rtosis 0.28025

Se$ness 0.141207 Se$ness 0.24858

!ange 34 !ange 26

ini'&' 28 ini'&' 28

axi'&' 62 axi'&' 54

S&' 920 S&' 827

*o&nt 20 *o&nt 20

4.411322 3.27531*on;%ence#evel<95.0=>

*on;%ence#evel<95.0=>

Page 10: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 10/43

298606214.xlsx

Page 10

Control

ean 39.25

Stan%ar% rror 1.8480074618

e%ian 37.5

o%e 37

Stan%ar% eviation 8.2645406151

-ariance 68.302631579

&rtosis 1.472660678

Se$ness 1.1801137856

!ange 32

ini'&' 28

axi'&' 60

S&' 785

*o&nt 20

*on;%ence #evel <95=> 3.6220280683

*on;%ence #evel 0.95

 )is tec)ni&e

&ses or'&lasrat)er t)an t)e

Analsis oolPa.

Page 11: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 11/43

298606214.xlsx

Page 11

Method1 Method2

46 41.35

2.1076302482 1.5648692564

45.5 41.5

52 37

9.4256090129 6.9983080662

88.8421052632 48.9763157895

0.4769944983 0.2802537627

0.1412071796 0.2485792637

34 26

28 28

62 54

920 827

20 20

4.1308793792 3.067087383

0.95 0.95

Page 12: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 12/43

xonential S'oot)ing

Page 12

Month "#tual

 ?an&ar 1@000 rr:512

Fer&ar 1@455 1@000

arc) 1@899 1318.5

Aril 1@433 1724.85

a 1@900 1520.555

 ?&ne 2@133 1786.167

 ?&l 1@800 2028.95

A&g&st 2@490 1868.685

Sete'er 3@000 2303.605

,ctoer 3@244 2791.082

+ove'er 4@598 3108.124

ece'er 5@409 4151.037

1 2 3 4

0

1@000

2@000

3@000

4@000

5@000

6@000!xon

Act&al For

&alue

Page 13: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 13/43

xonential S'oot)ing

Page 13

5 6 7 8 9 10 11 12

ential Smoothing

cast

$ata %oint

Page 14: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 14/43

Fest

Page 14

'rou 1 'rou 2   Fest $oSa'le or -ariances

96 39

78 53 Group 1 Group 2 

72 51 ean 75.44444 46.66667

78 48 -ariance 109.5278 25

65 51 ,servations 9 9

66 42 % 8 8

69 44 F 4.381111

87 42 P<FBC> onetail 0.025855

68 50 F *ritical onetail 3.438103

Page 15: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 15/43

298606214.xlsx

Page 15

$ata

62.7032 Bin Frequency Cumulative % Bin Frequency  

61.9644 32.74 1 .83= 53.08 24

48.4459 36.13 5 5.00= 56.47 21

46.4671 39.52 6 10.00= 49.69 16

55.0198 42.91 9 17.50= 59.86 16

59.1084 46.30 12 27.50= 46.30 12

54.5061 49.69 16 40.83= 42.91 9

66.639 53.08 24 60.83= 63.25 9

53.0802 56.47 21 78.33= 39.52 6

43.1949 59.86 16 91.67= 36.13 5

49.663 63.25 9 99.17= 32.74 1

51.4588 ore 1 100.00= ore 1

55.924

47.2721

55.257547.9575

54.4188

50.6749

51.1567

43.6882

60.5192

56.4548

61.6604

53.4031

62.579546.5224

61.7967

35.4543

61.4078

49.1092

46.8015

49.4497

48.7536

56.5109

51.678446.613

41.5251

53.7788

42.8329

57.3715

50.0444

53.08 56.47 49.69 59.86 46.30 42.91 63.25 39.52 36.13

0

5

10

15

20

25

30Histogram

Fre&en

*&'&la

(in

)re*uen#+

Page 16: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 16/43

298606214.xlsx

Page 16

39.6795

53.5558

50.7105

53.8893

35.0389

35.0036

42.0054

43.7896

54.6771

52.4236

58.8612

46.6317

53.5903

55.761

53.0703

52.943657.9183

57.9745

43.5655

37.5843

59.2086

40.0997

51.427

52.4416

60.0616

39.326337.4771

40.8728

52.2697

56.1913

57.7064

43.8317

45.1284

48.7424

51.788

58.858945.9285

45.4271

52.4416

57.1133

38.9637

58.5254

Page 17: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 17/43

298606214.xlsx

Page 17

59.1365

36.3993

53.957

46.0914

42.2223

55.4697

40.4445

49.1517

43.6757

59.0944

56.6284

56.4489

52.9011

54.1588

58.8521

46.480651.9951

52.634

38.1997

50.5417

42.6965

51.0578

54.6836

32.7379

45.2793

61.25152.1482

50.1735

33.5582

34.9176

44.889

52.166

49.5668

51.0949

50.2457

56.824455.9304

Page 18: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 18/43

298606214.xlsx

Page 18

Cumulative %

20.00=

37.50=

50.83=

64.17=

74.17=

81.67=

89.17=

94.17=

98.33=

99.17=

100.00=

32.74

0=

20=

40=

60=

80=

100=

120=

c

ive =

Page 19: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 19/43

298606214.xlsx

Page 19

Page 20: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 20/43

298606214.xlsx

Page 20

Page 21: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 21/43

298606214.xlsx

Page 21

Measurements Mo,ing ",g

112 rr:512

111 rr:512

181 rr:512

154 rr:512

100 rr:512

87 rr:512

193 rr:512

170 rr:512

78   135.7

171   138.5

140   147.6

202   144.6

151   140

108   142.4

124   147.1134   147.2

194   145.5

153   149.2

115   152.6

205   144.2

56   140.2

162   138

129   143.3

161   145.9

150   147.9154   141

125   132.2

65   130.9

102   129.6

192   144.2

202   147.2

192   148.3

140   148.7

165   144.9

112

  146165   148.9

154   163.2

208   167.9

149   167.2

185   165

180   156.1

0

50

100

150

200

250

300

&alue

Page 22: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 22/43

298606214.xlsx

Page 22

103   168.5

264   161.9

99   163.8

131   162.9

156   161.4

139   163.1

225   163.7

155   166.4

212   167.1

187   171.1

143   168.6

239   179.4

207   182.7

164   185.7

186   184

122   173.1116   173.2

156   165.3

133   163.4

168   166.8

177   151

81   150.4

201   146.5

125   142.7

148   147.4

169   152.7169   155

179   158.9

172   158.7

166   161.5

205   170.7

173   175.6

250   182.6

195   183.4

156   187.9

214

  197.1261   205.6

264   205.9

175   208.5

192   205.8

178   210.2

217   206.5

Page 23: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 23/43

298606214.xlsx

Page 23

213   200.9

139   202

167   195.6

150   187.4

179   174.4

134   171.8

149   169.4

168   173.4

218   172.4

207   171.4

203   180.8

233   189

249   191

170   192.1

190   207.2

285   220.6283

Page 24: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 24/43

298606214.xlsx

Page 24

Mo,ing ",erage

Act&al

oving Avg

$ata %oint

Page 25: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 25/43

298606214.xlsx

Page 25

Page 26: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 26/43

298606214.xlsx

Page 26

Page 27: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 27/43

!an%o' +&'ers

Page 27

-niorm Normal (enoulli (inomial %oisson %atterned

0.382000183 1.467033144 1 3 0 1

0.100680563 1.18270918 1 3 0 1

0.596484268 0.329373506 1 3 2 1

0.899105808 0.70603392 1 1 1 1

0.884609516 1.45068043 1 3 0 1

0.958464309 0.22961217 0 3 1 4

0.014496292 1.487419468 0 3 1 4

0.407422102 1.570383574 0 4 1 4

0.863246559 2.563865564 0 1 2 4

0.138584552 0.30460569 1 1 1 4

0.245033113 0.09303562 1 2 0 7

0.045472579 0.587413069 0 5 0 7

0.032380139 0.19414756 1 4 0 7

0.164128544 0.79910933 0 1 4 7

0.219611194 1.67898179 0 1 0 70.017090365 0.393392838 1 2 1 10

0.285042879 0.92736173 0 5 1 10

0.343089084 0.68337158 1 6 2 10

0.55363628 0.927052497 1 4 0 10

0.357371746 0.28823365 0 0 0 10

0.371837519 1.053754204 0 4 1 1

0.355601672 0.33571155 1 3 1 1

0.910306101 0.478581796 1 6 1 1

0.46601764 0.291862534 1 1 0 1

0.426160466 0.83018904 0 2 1 10.303903317 2.50965968 1 2 0 4

0.975707266 1.130026703 0 2 0 4

0.806665242 2.04940079 0 2 0 4

0.991241188 0.543964234 1 3 1 4

0.256263924 0.33650849 0 1 2 4

0.951689199 0.617601472 1 2 1 7

0.05343791 1.47256287 0 0 0 7

0.705038606 1.647867975 1 0 0 7

0.816522721 0.81690132 0 2 0 7

0.972502823 1.38430323 1 3 1 70.466322825 0.411577048 0 3 1 10

0.300210578 1.185248948 0 5 1 10

0.750206 0.613647444 0 1 0 10

0.351481674 0.6728169 0 0 0 10

0.775658437 0.474611852 0 1 3 10

0.074343089 0.619058937 0 3 0 1

Page 28: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 28/43

!an%o' +&'ers

Page 28

0.198431349 0.791117145 0 2 1 1

0.064058351 0.77036248 1 2 0 1

0.358348338 1.01450041 0 1 0 1

0.487044893 1.01142177 0 2 2 1

0.511215552 0.31953846 1 3 1 4

0.373455 0.639322479 0 4 1 4

0.985900449 1.417042768 0 4 0 4

0.040711692 1.101784619 1 3 1 4

0.230719932 0.38363396 0 4 1 4

0.004974517 0.587269824 0 3 1 7

0.926145207 1.64751782 0 0 1 7

0.100314341 1.060707291 1 1 3 7

0.256691183 1.583589437 1 4 1 7

0.775688955 1.371527105 1 6 0 7

0.679647206 0.28297109 1 1 1 10

0.809106723 0.37793825 1 2 0 100.724326304 1.859734766 1 2 0 10

0.085055086 0.73905426 1 2 1 10

0.13226722 0.19589152 0 3 0 10

0.756157109 1.36352355 0 2 0 1

0.626514481 0.40467626 1 1 1 1

0.173650319 0.20592324 1 4 1 1

0.40479751 0.176055437 1 2 0 1

0.552323984 1.667685865 0 3 2 1

0.71150853 1.077041816 1 2 1 4

0.555162206 1.30235549 1 7 1 40.181157872 1.468015398 1 0 2 4

0.970274972 0.18528226 1 2 3 4

0.68694113 1.326470738 0 2 0 4

0.528794214 0.46062155 0 1 2 7

0.79668569 0.951079073 1 6 1 7

0.805658132 1.733865247 1 2 0 7

0.262215033 1.436201273 0 2 3 7

0.177953429 2.640590537 1 2 3 7

0.866756188 0.176573849 1 1 0 10

0.114841151 1.675889507 1 2 1 100.059511093 0.853697202 1 2 0 10

0.761558885 1.68500264 1 4 0 10

0.738395337 1.391138085 1 4 2 10

0.986297189 2.238339221 0 3 2 1

0.925595874 0.06797791 0 4 0 1

0.903866695 0.198904218 1 4 1 1

Page 29: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 29/43

!an%o' +&'ers

Page 29

0.544969024 1.341686584 1 5 1 1

0.500778222 0.857128271 0 4 1 1

0.674977874 0.32953494 0 3 1 4

0.489822077 0.204354365 1 4 2 4

0.14578692 0.978261596 0 1 0 4

0.037965026 0.981660833 1 3 0 4

0.796258431 1.41606506 0 2 2 4

0.671559801 1.777343641 1 0 1 7

0.731681265 0.22524091 0 3 1 7

0.584521012 0.31483296 1 3 0 7

0.152226325 1.02017339 1 5 0 7

0.892178106 1.334819899 0 3 2 7

0.377819147 0.914601515 1 1 0 10

0.200476089 0.08856659 1 1 1 10

0.205786309 0.99266344 0 3 1 10

0.333964049 1.106573109 1 3 1 100.3251442 1.023340701 0 1 2

Page 30: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 30/43

!an D Percentile

Page 30

Sales/e Sales Point Sales )an* Percent  

Allen 137@676 4 197@107 1 100.00=

ran%on 155@449 3 180@414 2 94.40=

*a'aigne 180@414 17 170@538 3 88.80=

&energ 197@107 14 161@750 4 83.30=

Fox 130@814 2 155@449 5 77.70=

/iles 133@283 11 151@466 6 72.20=

(aEic) 116@943 19 149@627 7 66.60=

(osaa 107@684 12 145@088 8 61.10=

 ?enson 128@060 1 137@676 9 55.50=

#arson 121@336 18 134@395 10 50.00=

#eitc) 151@466 6 133@283 11 44.40=

iller 145@088 5 130@814 12 38.80=

Peterson 127@995 9 128@060 13 33.30=

!ic)ar%s 161@750 13 127@995 14 27.70=

!ic)ar%son 117@203 10 121@336 15 22.20=!an 102@571 15 117@203 16 16.60=

Serrano 170@538 7 116@943 17 11.10=

Str& 134@395 8 107@684 18 5.50=

inre 149@627 16 102@571 19 .00=

Page 31: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 31/43

!an D Percentile

Page 31

Sales/e Sales /an0  

Allen 137@676 9

ran%on 155@449 5

*a'aigne 180@414 2

&energ 197@107 1

Fox 130@814 12

/iles 133@283 11

(aEic) 116@943 17

(osaa 107@684 18

 ?enson 128@060 13

#arson 121@336 15

#eitc) 151@466 6

iller 145@088 8

Peterson 127@995 14

!ic)ar%s 161@750 4

!ic)ar%son 117@203 16!an 102@571 19

Serrano 170@538 3

Str& 134@395 10

inre 149@627 7

 )is tec)ni&e&ses or'&lasrat)er t)an t)e

Analsis oolPa.

Page 32: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 32/43

!an D Percentile

Page 32

%er#ent

55.56=

77.78=

94.44=

100.00=

38.89=

44.44=

11.11=

5.56=

33.33=

22.22=

72.22=

61.11=

27.78=

83.33=

16.67=0.00=

88.89=

50.00=

66.67=

Page 33: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 33/43

298606214.xlsx

Page 33

Months "d, $i $eosits

 ?an 4@927 10 2@071@149 SUA!" ,UPU

Fe 6@438 13 1@468@635

ar 5@616 6 1@780@402 )egression St 

Ar 10@672 12 2@349@637 &ltile !

a 11@283 33 1@069@804 ! S&are

 ?&n 5@845 31 732@188 A%&ste% ! S&are

 ?&l 4@911 10 881@976 Stan%ar% rror

A&g 375 1 700@024 ,servations

Se 7@656 3 1@391@848

,ct 9@088 10 1@981@800 A+,-A

+ov 5@545 14 2@469@982

ec 4@551 14 1@759@743 !egression

 ?an 4@466 14 1@538@353 !esi%&al

Fe 5@524 13 1@442@750 otal

ar 5@927 19 1@547@134

Ar 5@494 11 1@320@301

a 3@283 0 948@765 Gntercet

 ?&n 5@678 9 818@945 H -ariale 1

H -ariale 2

!SGUA# ,UPU

+,servation

1

2

3

4

5

6

7

8

9

1011

12

13

14

15

16

Page 34: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 34/43

298606214.xlsx

Page 34

17

18

0 2@000 4@000 6@00

1000000

500000

0

500000

1000000

&ariale 1 /esid

&ariale

/esiduals

0 5@000 10@000

0

1@000@000

2@000@000

3@000@000

&ariale 1 Line

&ariale 1

  

40 30 20 10 0 10

0

1@000@000

2@000@000

3@000@000

&ariale 2 Line

&ariale 2

  

Page 35: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 35/43

298606214.xlsx

Page 35

  tistics

0.7650994049

0.5853770994

0.530094046

370049.27044

18

df SS MS F  

2 2899965335149 1449982667574.67 10.588725899

15 2054046938283 136936462552.178

17 4954012273432

Coecients Standard (rror t Stat P-value

716434.66148 238757.332427 3.0006812951 0.0089602984

107.68009435 36.2070949857 2.9740053541 0.0094602223

25010.948657 6185.924172279 4.0432032402 0.0010618542

Predicted . )esiduals Standard )esiduals

1497083.9729 574065.0271022 1.6515068092

1734821.4414 266186.441426 0.7657820975

1471231.7633 309170.2367272 0.8894406157

2165728.0122 183908.9877715 0.5290810818

1106027.8603 36223.86029571 0.1042111069

570485.40456 161702.5954417 0.4651963189

995142.11824 113166.1182425 0.325563492

731803.74821 31779.74820592 0.0914260024

1615866.3098 224018.3097662 0.6444701323

1945140.8455 36659.15452971 0.10546338911663674.0658 806307.9341674 2.3196379865

1556640.0521 203102.9479471 0.5842994882

1547487.244 9134.244033565 0.0262779746

1636401.8352 193651.835194 0.5571099254

1829862.6052 282728.6051591 0.813371647

1583149.535 262848.5350491 0.7561793959

/egression anal+sis or an0 deosits.

Gn%een%ent -ariales:A%v C A'o&nt sent on a%vertising. iI C Gnterest rate ai%@ relative to co'etition <in

een%ent -ariale:eosits C +e$ %eosits receive%.

Page 36: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 36/43

298606214.xlsx

Page 36

1069948.4112 121183.4112205 0.3486281507

1552940.7751 733995.7750941 2.1116057646

8@000 10@000 12@000

al %lot

 

40 30 20 10

100000

50000

50000

100000

&ariale 2 /esi

&aria

/esiduals

15@000

  it %lot

 "

Pre%icte% "

20 30

  it %lot

 "

Pre%icte% "

0 20 40 60

0

1000000

2000000

3000000

Normal %roail

Samle %er#en

  

Page 37: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 37/43

298606214.xlsx

Page 37

Signi/cance F 

0.001356437

0o'er 1%2 3pper 1%2 0o'er 1%&42 3pper 1%&42

207535.453783019 1225333.8692 207535.45378 1225333.8692

30.5064981923 184.8536905 30.506498192 184.8536905

11825.9633914184 38195.933923 11825.963391 38195.933923

P!,AG#G" ,UPU

Percentile .  

2.7777777778 700024

8.3333333333 732188

13.8888888889 818945

19.4444444444 881976

25 948765

30.5555555556 1069804

36.1111111111 1320301

41.6666666667 1391848

47.2222222222 1442750

52.7777777778 146863558.3333333333 1538353

63.8888888889 1547134

69.4444444444 1759743

75 1780402

80.5555555556 1981800

86.1111111111 2071149

  asis oints>.

Page 38: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 38/43

298606214.xlsx

Page 38

91.6666666667 2349637

97.2222222222 2469982

0 10 20 30

0

0

0

0

0

ual %lot

le 2

80 100 120

it+ %lot

tile

Page 39: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 39/43

Sa'ling

Page 39

%oulation Samle

10.29797 7.673046 12.38986 9.367033

15.00142 8.660007 7.092125 9.422776

9.700085 11.32997 9.213798 7.121572

10.46191 10.70228 10.69075 10.48574

14.22629 13.92461 8.144999 8.660007

16.48539 12.36356 13.18553 4.599184

9.885861 11.42079 7.163229 7.092125

7.270315 6.502152 10.61768 13.43524

11.91267 8.237665 13.71438 8.660007

7.121572 10.88679 7.65776 10.12462

4.765376 17.80292 10.48574

8.652951 12.8515 10.12462 8.89683 Sa'le 'ean

9.367033 6.829679 8.213528

9.458601 9.707411 7.374939

13.44868 16.87829 13.243455.9449 12.26302 8.584319

7.615029 6.525398 4.599184

13.3677 10.12982 7.489795

13.43524 13.91232 9.422776

9.830936 4.286336 8.539644

Po&lation ean: 10.15143

Page 40: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 40/43

298606214.xlsx

Page 40

Student %retest %osttest   test: Paire% $o Sa'le or eans

1 71 69

2 63 61

3 68 70 ean

4 67 68 -ariance

5 66 61 ,servations

6 63 60 Pearson *orrelation

7 76 83 (ot)esiJe% ean iIerence

8 70 72 %  

9 69 71 t Stat

10 73 77 P<BCt> onetail

11 71 72 t *ritical onetail

12 66 66 P<BCt> t$otail

13 70 71 t *ritical t$otail

14 78 86

15 68 7016 75 78

17 65 63

18 67 68

19 71 77

20 74 78

21 71 72

Page 41: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 41/43

298606214.xlsx

Page 41

Pretest Posttest  

69.6190476 71.095238

16.647619 48.790476

21 21

0.96274299

0

20

2.0815216

0.02522239

1.724718

0.05044479

2.08596248

Page 42: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 42/43

298606214.xlsx

Page 42

Student Team61 Team62   Jest: $o Sa'le or eans

1 71 75

2 63 66

3 68 70 ean

4 67 68 no$n -ariance

5 66 67 ,servations

6 63 68 (ot)esiJe% ean iIerence

7 76 81 J

8 70 72 P<KBCJ> onetail

9 69 71 J *ritical onetail

10 73 77 P<KBCJ> t$otail

11 71 72 J *ritical t$otail

12 66 67

13 70 79

14 78 72

15 68 7316 75 78

17 65 69

18 67 69

19 71 77

20 74 78

21 71 72

ean 69.6190476 72.4285714

-ariance 15.8548753 19.0068027

Page 43: Atp Examples

7/23/2019 Atp Examples

http://slidepdf.com/reader/full/atp-examples 43/43

298606214.xlsx

eam-! eam-"

69.6190476 72.428571

15.855 19.007

21 21

0

2.1805508

0.01460828

1.644853

0.00730414

1.95996108