377595943.

xlsx

Low Medium High Control Anova: Single Factor

34 41 32 43
36 42 56 42 SUMMARY
42 38 53 41 Groups Count
51 53 28 37 Low 7
38 43 43 50 Medium 7
32 35 54 26 High 7
36 37 52 33 Control 7

ANOVA
Source of Variation SS
Between Groups 216.28571
Within Groups 1587.7143

Total 1804

Page 1
 377595943.xlsx

Sum Average Variance

269 38.428571 40.619048
289 41.285714 34.904762
318 45.428571 129.28571
272 38.857143 59.809524

df MS F P-value F crit
3 72.095238 1.0897967 0.3724329 3.0087866
24 66.154762

27

Page 2
 377595943.xlsx

Name Height Weight Sex Test1 Test2 Test3 Test4 Test5

Bill 74.2 176 1 90 86 134 65 9
Mike 68.5 132 1 90 87 122 31 67
Carol 65.0 157 0 82 75 145 2 6
Scott 73.2 199 1 90 79 109 7 92
Jill 65.8 154 0 100 92 132 79 73
Francis 52.4 101 0 78 89 176 18 50
Helen 69.2 157 0 90 84 103 64 87
Marci 69.0 148 0 65 54 123 100 32
Benedict 77.0 225 1 92 85 132 74 22
Hank 71.0 179 1 70 60 144 36 78
John 73.5 190 1 69 58 156 12 1
Susan 66.9 155 0 80 86 157 68 22
Gloria 67.1 190 0 89 77 98 23 25

This
This technique
techniqueuses
uses
formulas
formulas rather
rather than
than
the
theAnalysis
AnalysisToolPak.
ToolPak.

Height Weight Sex Test1 Test2 Test3 Test4 Test5

Height 1.0000
Weight 0.8403 1.0000
Sex 0.6708 0.5189 1.0000
Test1 0.0996 0.1635 0.0035 1.0000
Test2 -0.2805 -0.2244 -0.1533 0.8365 1.0000
Test3 -0.4374 -0.3845 -0.0136 -0.4450 -0.0203 1.0000
Test4 0.2272 0.0036 -0.2127 0.0784 0.0673 -0.1515 1.0000
Test5 -0.1016 -0.1777 0.0452 0.2894 0.2099 -0.3746 0.0127 1.0000

Page 3
 377595943.xlsx

Height Weight Sex Test1 Test2 Test3 Test4 Test5

Height 1.0000
Weight 0.8403 1.0000
Sex 0.6708 0.5189 1.0000
Test1 0.0996 0.1635 0.0035 1.0000
Test2 -0.2805 -0.2244 -0.1533 0.8365 1.0000
Test3 -0.4374 -0.3845 -0.0136 -0.4450 -0.0203 1.0000
Test4 0.2272 0.0036 -0.2127 0.0784 0.0673 -0.1515 1.0000
Test5 -0.1016 -0.1777 0.0452 0.2894 0.2099 -0.3746 0.0127 1.0000

Page 4
 Covariance

Name Test1 Test2 Test3 Test4 Test5 Test1 Test2

Bill 1 1 134 65 9 Test1 14.0000
Mike 2 2 122 31 67 Test2 14.0000 14.0000
Carol 3 3 145 2 6 Test3 4.2308 4.2308
Scott 4 4 109 7 92 Test4 10.5722 10.5722
Jill 5 5 132 79 73 Test5 -23.9176 -23.9176
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

This
This technique
techniqueuses
uses
formulas
formulas rather
rather than
than
the
theAnalysis
AnalysisToolPak.
ToolPak.

Test1 Test2 Test3 Test4 Test5

Test1 14.0000
Test2 14.0000 14.0000
Test3 4.2308 4.2308 472.5917
Test4 10.5722 10.5722 ### 937.5172
Test5 -23.9176 -23.9176 ### 12.0757 970.6370

Page 5
 Covariance

Test3 Test4 Test5

472.5917
### 937.5172
### 12.0757 970.6370

Page 6
 377595943.xlsx

W. Coast Midwest E. Coast

Sample Sample Sample W. Coast Sample Midwest Sample
35 41 52
32 35 29 Mean 39.25 Mean
46 36 43 Standard Error 1.848007 Standard Error
57 45 45 Median 37.5 Median
45 44 28 Mode 37 Mode
28 62 35 Standard Deviation 8.264541 Standard Deviation
60 61 37 Sample Variance 68.30263 Sample Variance
37 62 32 Kurtosis 1.472661 Kurtosis
34 36 37 Skewness 1.180114 Skewness
33 52 41 Range 32 Range
37 46 54 Minimum 28 Minimum
32 52 44 Maximum 60 Maximum
38 38 42 Sum 785 Sum
41 28 48 Count 20 Count
Confidence Confidence
38 50 46 Level(95.0%) 3.867925 Level(95.0%)
42 52 47
29 48 39
40 38 40
37 44 41
44 50 47

Page 7
 377595943.xlsx

E. Coast Sample
Mean
46 Mean 41.35 This
This technique
techniqueuses
uses Standard Error
formulas
formulasrather
rather than
than
2.10763 Standard Error 1.564869 the
the Analysis
Analysis ToolPak.
ToolPak. Median
45.5 Median 41.5 Mode
52 Mode 37 Standard Deviation
9.425609 Standard Deviation 6.998308 Variance
88.84211 Sample Variance 48.97632 Kurtosis
-0.47699 Kurtosis -0.28025 Skewness
0.141207 Skewness -0.24858 Range
34 Range 26 Minimum
28 Minimum 28 Maximum
62 Maximum 54 Sum
920 Sum 827 Count
20 Count 20 Confidence Level (95%)
Confidence
4.411322 Level(95.0%) 3.27531 Confidence Level

Page 8
 377595943.xlsx

Control Method1 Method2

39.25 46 41.35
1.848007462 2.1076302482 1.5648692564
37.5 45.5 41.5
37 52 37
8.264540615 9.4256090129 6.9983080662
68.30263158 88.8421052632 48.9763157895
1.472660678 -0.4769944983 -0.2802537627
1.180113786 0.1412071796 -0.2485792637
32 34 26
28 28 28
60 62 54
785 920 827
20 20 20
3.622028068 4.1308793792 3.067087383

0.95 0.95 0.95

Page 9
 Exponential Smoothing

Month Actual
January 1,000 #N/A
February 1,455 1,000 Exponential Smoothing
6,000
March 1,899 1318.5
April 1,433 1724.85
5,000 Actual
May 1,900 1520.555
Forecast
June 2,133 1786.167

Value
4,000
July 1,800 2028.95
August 2,490 1868.685 3,000
September 3,000 2303.605
October 3,244 2791.082 2,000
November 4,598 3108.124
December 5,409 4151.037 1,000

0
1 2 3 4 5 6 7 8 9 1
Data Point

Page 10
 Exponential Smoothing

al Smoothing

6 7 8 9 10 11 12
Data Point

Page 11
 F-Test

Group 1 Group 2 F-Test Two-Sample for Variances

96 39
78 53 Group 1 Group 2
72 51 Mean 75.44444 46.66667
78 48 Variance 109.5278 25
65 51 Observations 9 9
66 42 df 8 8
69 44 F 4.381111
87 42 P(F<=f) one-tail 0.025855
68 50 F Critical one-tail 3.438103

Page 12
 377595943.xlsx

Data
62.7032 Bin Frequency Cumulative % Bin Frequency Cumulative %
61.9644 32.74 1 .83% 53.08 24 20.00%
48.4459 36.13 5 5.00% 56.47 21 37.50%
46.4671 39.52 6 10.00% 49.69 16 50.83%
55.0198 42.91 9 17.50% 59.86 16 64.17%
59.1084 46.30 12 27.50% 46.30 12 74.17%
54.5061 49.69 16 40.83% 42.91 9 81.67%
66.639 53.08 24 60.83% 63.25 9 89.17%
53.0802 56.47 21 78.33% 39.52 6 94.17%
43.1949 59.86 16 91.67% 36.13 5 98.33%
49.663 63.25 9 99.17% 32.74 1 99.17%
51.4588 More 1 100.00% More 1 100.00%
55.924
47.2721
55.2575
47.9575
54.4188
50.6749
51.1567
Histogram
30 120%
43.6882
Frequency

60.5192 25 100%
56.4548
61.6604 20 80%
Frequency
53.4031 Cumulative
62.5795 15 % 60%
46.5224
61.7967 10 40%
35.4543
61.4078 5 20%
49.1092
46.8015 0 0%
49.4497 53.08 56.47 49.69 59.86 46.30 42.91 63.25 39.52 36.13 32.74
48.7536 Bin
56.5109
51.6784
46.613
41.5251
53.7788
42.8329
57.3715
50.0444
39.6795

Page 13
 377595943.xlsx

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.9436
57.9183
57.9745
43.5655
37.5843
59.2086
40.0997
51.427
52.4416
60.0616
39.3263
37.4771
40.8728
52.2697
56.1913
57.7064
43.8317
45.1284
48.7424
51.788
58.8589
45.9285
45.4271
52.4416
57.1133
38.9637
58.5254
59.1365
36.3993

Page 14
 377595943.xlsx

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.4806
51.9951
52.634
38.1997
50.5417
42.6965
51.0578
54.6836
32.7379
45.2793
61.251
52.1482
50.1735
33.5582
34.9176
44.889
52.166
49.5668
51.0949
50.2457
56.8244
55.9304

Page 15
 377595943.xlsx

Measurements #N/A
112 #N/A
111 #N/A
181 #N/A Moving Average
154 #N/A 300
100 #N/A
87 #N/A
193 #N/A 250
170 #N/A
78 135.7
171 138.5 200
140 147.6
202 144.6
151 140 Value 150
108 142.4
124 147.1
100
134 147.2
194 145.5
153 149.2
50
115 152.6
205 144.2
56 140.2 0
162 138 1 6 11 16 2 1 2 6 31 36 41 46 51 56 61 66 71 76 81 86 91
129 143.3
161 145.9 Data Point
150 147.9
154 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 146
165 148.9
154 163.2
208 167.9
149 167.2
185 165
180 156.1
103 168.5

Page 16
 377595943.xlsx

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.1
116 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.7
169 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.1
261 205.6
264 205.9
175 208.5
192 205.8
178 210.2
217 206.5
213 200.9
139 202

Page 17
 377595943.xlsx

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.6
283

Page 18
 377595943.xlsx

Average

Actual
Forecast

56 61 66 71 76 81 86 91 96

Page 19
 Random Numbers

Uniform Normal Benoulli Binomial Poisson Patterned

0.38200018 1.46703314 1 3 0 1
0.10068056 -1.18270918 1 3 0 1
0.59648427 0.32937351 1 3 2 1
0.89910581 -0.70603392 1 1 1 1
0.88460952 -1.45068043 1 3 0 1
0.95846431 -0.22961217 0 3 1 4
0.01449629 1.48741947 0 3 1 4
0.4074221 1.57038357 0 4 1 4
0.86324656 2.56386556 0 1 2 4
0.13858455 -0.30460569 1 1 1 4
0.24503311 -0.09303562 1 2 0 7
0.04547258 0.58741307 0 5 0 7
0.03238014 -0.19414756 1 4 0 7
0.16412854 0.79910933 0 1 4 7
0.21961119 -1.67898179 0 1 0 7
0.01709037 0.39339284 1 2 1 10
0.28504288 -0.92736173 0 5 1 10
0.34308908 -0.68337158 1 6 2 10
0.55363628 0.9270525 1 4 0 10
0.35737175 -0.28823365 0 0 0 10
0.37183752 1.0537542 0 4 1 1
0.35560167 -0.33571155 1 3 1 1
0.9103061 0.4785818 1 6 1 1
0.46601764 0.29186253 1 1 0 1
0.42616047 -0.83018904 0 2 1 1
0.30390332 2.50965968 1 2 0 4
0.97570727 1.1300267 0 2 0 4
0.80666524 -2.04940079 0 2 0 4
0.99124119 0.54396423 1 3 1 4
0.25626392 -0.33650849 0 1 2 4
0.9516892 0.61760147 1 2 1 7
0.05343791 -1.47256287 0 0 0 7
0.70503861 1.64786798 1 0 0 7
0.81652272 -0.81690132 0 2 0 7
0.97250282 -1.38430323 1 3 1 7
0.46632282 0.41157705 0 3 1 10
0.30021058 1.18524895 0 5 1 10
0.750206 0.61364744 0 1 0 10
0.35148167 -0.6728169 0 0 0 10
0.77565844 0.47461185 0 1 3 10
0.07434309 0.61905894 0 3 0 1
0.19843135 0.79111715 0 2 1 1

Page 20
 Random Numbers

0.06405835 -0.77036248 1 2 0 1
0.35834834 -1.01450041 0 1 0 1
0.48704489 -1.01142177 0 2 2 1
0.51121555 -0.31953846 1 3 1 4
0.373455 0.63932248 0 4 1 4
0.98590045 1.41704277 0 4 0 4
0.04071169 1.10178462 1 3 1 4
0.23071993 0.38363396 0 4 1 4
0.00497452 0.58726982 0 3 1 7
0.92614521 1.64751782 0 0 1 7
0.10031434 1.06070729 1 1 3 7
0.25669118 1.58358944 1 4 1 7
0.77568896 1.37152711 1 6 0 7
0.67964721 -0.28297109 1 1 1 10
0.80910672 0.37793825 1 2 0 10
0.7243263 1.85973477 1 2 0 10
0.08505509 -0.73905426 1 2 1 10
0.13226722 -0.19589152 0 3 0 10
0.75615711 -1.36352355 0 2 0 1
0.62651448 -0.40467626 1 1 1 1
0.17365032 -0.20592324 1 4 1 1
0.40479751 0.17605544 1 2 0 1
0.55232398 1.66768586 0 3 2 1
0.71150853 1.07704182 1 2 1 4
0.55516221 -1.30235549 1 7 1 4
0.18115787 1.4680154 1 0 2 4
0.97027497 -0.18528226 1 2 3 4
0.68694113 1.32647074 0 2 0 4
0.52879421 -0.46062155 0 1 2 7
0.79668569 0.95107907 1 6 1 7
0.80565813 1.73386525 1 2 0 7
0.26221503 1.43620127 0 2 3 7
0.17795343 2.64059054 1 2 3 7
0.86675619 0.17657385 1 1 0 10
0.11484115 1.67588951 1 2 1 10
0.05951109 0.8536972 1 2 0 10
0.76155889 -1.68500264 1 4 0 10
0.73839534 1.39113808 1 4 2 10
0.98629719 2.23833922 0 3 2 1
0.92559587 -0.06797791 0 4 0 1
0.9038667 0.19890422 1 4 1 1
0.54496902 1.34168658 1 5 1 1
0.50077822 0.85712827 0 4 1 1

Page 21
 Random Numbers

0.67497787 -0.32953494 0 3 1 4
0.48982208 0.20435436 1 4 2 4
0.14578692 0.9782616 0 1 0 4
0.03796503 0.98166083 1 3 0 4
0.79625843 -1.41606506 0 2 2 4
0.6715598 1.77734364 1 0 1 7
0.73168126 -0.22524091 0 3 1 7
0.58452101 0.31483296 1 3 0 7
0.15222633 -1.02017339 1 5 0 7
0.89217811 1.3348199 0 3 2 7
0.37781915 0.91460151 1 1 0 10
0.20047609 -0.08856659 1 1 1 10
0.20578631 -0.99266344 0 3 1 10
0.33396405 1.10657311 1 3 1 10
0.3251442 1.0233407 0 1 2

Page 22
 Rank & Percentile

SalesRep Sales Point Sales Rank Percent

Allen 137,676 4 197,107 1 100.00%
Brandon 155,449 3 180,414 2 94.40%
Campaigne 180,414 17 170,538 3 88.80%
Dufenberg 197,107 14 161,750 4 83.30%
Fox 130,814 2 155,449 5 77.70%
Giles 133,283 11 151,466 6 72.20%
Haflich 116,943 19 149,627 7 66.60%
Hosaka 107,684 12 145,088 8 61.10%
Jenson 128,060 1 137,676 9 55.50%
Larson 121,336 18 134,395 10 50.00%
Leitch 151,466 6 133,283 11 44.40%
Miller 145,088 5 130,814 12 38.80%
Peterson 127,995 9 128,060 13 33.30%
Richards 161,750 13 127,995 14 27.70%
Richardson 117,203 10 121,336 15 22.20%
Ryan 102,571 15 117,203 16 16.60%
Serrano 170,538 7 116,943 17 11.10%
Struyk 134,395 8 107,684 18 5.50%
Winfrey 149,627 16 102,571 19 .00%

Page 23
 Rank & Percentile

SalesRep Sales Rank Percent

Allen 137,676 9 55.56%
Brandon 155,449 5 77.78%
This
This technique
techniqueuses
uses Campaigne 180,414 2 94.44%
formulas
formulas rather
rather than
than Dufenberg 197,107 1 100.00%
the
theAnalysis
Analysis ToolPak.
ToolPak.
Fox 130,814 12 38.89%
Giles 133,283 11 44.44%
Haflich 116,943 17 11.11%
Hosaka 107,684 18 5.56%
Jenson 128,060 13 33.33%
Larson 121,336 15 22.22%
Leitch 151,466 6 72.22%
Miller 145,088 8 61.11%
Peterson 127,995 14 27.78%
Richards 161,750 4 83.33%
Richardson 117,203 16 16.67%
Ryan 102,571 19 0.00%
Serrano 170,538 3 88.89%
Struyk 134,395 10 50.00%
Winfrey 149,627 7 66.67%

Page 24
 377595943.xlsx

Months Adv bp Dif Deposits

Jan 4,927 10 2,071,149 SUMMARY OUTPUT
Feb 6,438 13 1,468,635
Mar 5,616 6 1,780,402 Regression Statistics
Regression
Regressionanalysis
analysisfor
forbank
bank
Apr 10,672 12 2,349,637 Multiple R 0.765099405
May 11,283 -33 1,069,804 R Square 0.585377099 Independent
IndependentVariables:
Variables:
Adv
Adv==Amount
Amountspent
spentononadve
adve
Jun 5,845 -31 732,188 Adjusted R Square 0.530094046 bp
bpDiff
Diff==Interest
Interestrate
ratepaid,
paid,re
r
Jul 4,911 -10 881,976 Standard Error 370049.2704
Dependent
DependentVariable:
Variable:
Aug 375 -1 700,024 Observations 18 Deposits
Deposits==New
Newdeposits
depositsrece
rec
Sep 7,656 3 1,391,848
Oct 9,088 10 1,981,800 ANOVA
Nov 5,545 14 2,469,982 df SS
Dec 4,551 14 1,759,743 Regression 2 2899965335149
Jan 4,466 14 1,538,353 Residual 15 2054046938283
Feb 5,524 13 1,442,750 Total 17 4954012273432
Mar 5,927 19 1,547,134
Apr 5,494 11 1,320,301 Coefficients Standard Error
May 3,283 0 948,765 Intercept 716434.6615 238757.332427
Jun 5,678 9 818,945 X Variable 1 107.6800943 36.2070949857
X Variable 2 25010.94866 6185.924172279

RESIDUAL OUTPUT

Observation Predicted Y Residuals

1 1497083.973 574065.0271022
2 1734821.441 -266186.441426
3 1471231.763 309170.2367272
4 2165728.012 183908.9877715
5 1106027.86 -36223.8602957
6 570485.4046 161702.5954417
7 995142.1182 -113166.118242
8 731803.7482 -31779.7482059
9 1615866.31 -224018.309766
10 1945140.845 36659.15452971
11 1663674.066 806307.9341674
12 1556640.052 203102.9479471
13 1547487.244 -9134.24403357
14 1636401.835 -193651.835194
15 1829862.605 -282728.605159
16 1583149.535 -262848.535049

Page 25
 377595943.xlsx

17 1069948.411 -121183.411221
18 1552940.775 -733995.775094

X Variable 1 Residual Plot XV

1000000
500000

Residuals
Residuals
0
0 2,000 4,000 6,000 8,000 10,000 12,000 -40 -30
-500000
-1000000
X Variable 1

X Variable 1 Line Fit Plot No

3,000,000 3000000
2,000,000
2000000
1,000,000 Y

Y
0 Predicted Y 1000000
Y

0 0 0 0 0 0 0 0 00
00 00 00 00 ,0 0
2, 4, 6, 8, 1 0 12
,
0
X Variable 1

X Variable 2 Line Fit Plot

3,000,000

2,000,000
Y
Predicted Y
Y

1,000,000

0
-40 -30 -20 -10 0 10 20 30
X Variable 2

Page 26
 377595943.xlsx

Regression
Regressionanalysis
analysisfor
forbank
bankdeposits.
deposits.
ndependent Variables:
Independent Variables:
Adv
Adv==Amount
Amountspent
spentononadvertising.
advertising.
bp
bpDiff
Diff==Interest
Interestrate
ratepaid,
paid,relative
relativeto
tocompetition
competition(in
(inbasis
basispoints).
points).
Dependent
DependentVariable:
Variable:
Deposits
Deposits==New
Newdeposits
depositsreceived.
received.

MS F Significance F
1449982667574.67 10.5887259 0.001356437
136936462552.178

t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
3.0006812951 0.008960298 207535.453783019 1225333.869 207535.45378 1225333.8692
2.9740053541 0.009460222 30.5064981923 184.8536905 30.506498192 184.8536905
4.0432032402 0.001061854 11825.9633914184 38195.93392 11825.963391 38195.933923

PROBABILITY OUTPUT

Standard Residuals Percentile Y

1.6515068092 2.7777777778 700024
-0.7657820975 8.3333333333 732188
0.8894406157 13.8888888889 818945
0.5290810818 19.4444444444 881976
-0.1042111069 25 948765
0.4651963189 30.5555555556 1069804
-0.325563492 36.1111111111 1320301
-0.0914260024 41.6666666667 1391848
-0.6444701323 47.2222222222 1442750
0.1054633891 52.7777777778 1468635
2.3196379865 58.3333333333 1538353
0.5842994882 63.8888888889 1547134
-0.0262779746 69.4444444444 1759743
-0.5571099254 75 1780402
-0.813371647 80.5555555556 1981800
-0.7561793959 86.1111111111 2071149

Page 27
 377595943.xlsx

-0.3486281507 91.6666666667 2349637

-2.1116057646 97.2222222222 2469982

X Variable 2 Residual Plot

1000000
500000
Residuals

0
-40 -30 -20 -10 0 10 20 30
-500000
-1000000
X Variable 2

Normal Probability Plot

3000000

2000000
Y

1000000

0
0 20 40 60 80 100 120
Sample Percentile

Page 28
 Sampling

Population Sample
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 Sample mean
9.367033 6.829679 8.213528
9.458601 9.707411 7.374939
13.44868 16.87829 13.24345
5.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

Population Mean: 10.15143

Page 29
 377595943.xlsx

Student# Pretest Posttest t-Test: Paired Two Sample for Means

1 71 69
2 63 61 Pretest Posttest
3 68 70 Mean 69.619048 71.095238
4 67 68 Variance 16.647619 48.790476
5 66 61 Observations 21 21
6 63 60 Pearson Correlation 0.962743
7 76 83 Hypothesized Mean Difference 0
8 70 72 df 20
9 69 71 t Stat -2.0815216
10 73 77 P(T<=t) one-tail 0.0252224
11 71 72 t Critical one-tail 1.724718
12 66 66 P(T<=t) two-tail 0.0504448
13 70 71 t Critical two-tail 2.0859625
14 78 86
15 68 70
16 75 78
17 65 63
18 67 68
19 71 77
20 74 78
21 71 72

Page 30
 377595943.xlsx

Student# Team-1 Team-2 z-Test: Two Sample for Means

1 71 75
2 63 66 Team-1 Team-2
3 68 70 Mean 69.619048 72.428571
4 67 68 Known Variance 15.855 19.007
5 66 67 Observations 21 21
6 63 68 Hypothesized Mean Difference 0
7 76 81 z -2.1805508
8 70 72 P(Z<=z) one-tail 0.0146083
9 69 71 z Critical one-tail 1.644853
10 73 77 P(Z<=z) two-tail 0.0073041
11 71 72 z Critical two-tail 1.9599611
12 66 67
13 70 79
14 78 72
15 68 73
16 75 78
17 65 69
18 67 69
19 71 77
20 74 78
21 71 72

Mean 69.619048 72.428571

Variance 15.854875 19.006803

Page 31