Nothing Special   »   [go: up one dir, main page]

Exercises

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 35

P(x<40000) 0.758036 value of x 30092.

24
Weight
162.2 Sample mean 166.7112
159.8 Sample proportion (m>100) 0.81
163.6
166.2 Lower Limit 165.0678
166 Upper Limit 168.3547
167.3
157.5
162.4
165.7
160.3
165.8
166.2
161.8
163.2
165.2
164.4
163.8
162.3
164
160.6
156.4
156.4
157.5
162.1
171.5
157.4
157.1
156.8000
156.6000
152.2
165.3
173.3
166.2
157.7
166.2
166.4
180.8
159.8
163.1
166.4
168.6
175.8
163.8
168
169.6
154.5
175.5
159.7
160
168.2
167
171.4
168
179.1
176.1
168.4
174.3
168
166.8
168.4
186.8
160.4
169.1
164.4
171.6
168
172.4
184.9
171
176.8
178.3
163
164.5
173.4
176.4
175.5
166.3
188.1
166
171.3
Highway Speeds
70
65 Sample mean 66
65
62
70 Lower limit 64.69963
64 Upper limit 67.30037
65
60
65
65
65
64
66
66
63
60
70
63
67
68
70
65
66
67
63
60
70
66
67
68
70
68
69
70
62
64
70
68
69
65
MPG
97 Column1
117
93 Confidence Level(90.0%) 3.6602748393
79
97
87
78
83
94 t-value 1.31783593367315
96
102
98
82
96
113
113
111
90
101
99
112
89
92
96
98
1.994945 0.930563
0.069437
52
44 sample mean 51.5
55 sample standard 6.840283
44 t-value 2.093024
45
59 Lower limit 48.29865
50 Upper limit 54.70135
54
62
46
54
42
60
62
43
42
48
55
57
56
Center A Center B
97 64 z-Test: Two Sample for Means
95 85
89 72 Center A Center B
79 64 Mean 82 78
78 74 Known Variance 10 10
87 93 Observations 30 40
83 70 Hypothesized Mean Difference 0
94 79 z 5.23722936566
76 79 P(Z<=z) one-tail 8.1502534E-08
79 75 z Critical one-tail 1.64485362695
83 66 P(Z<=z) two-tail 0.00000
84 83 z Critical two-tail 1.95996398454
76 74
82 70
85 82
85 82
91 75
72 78
86 99
70 57
91 91
82 78
73 87
96 93
64 89
74 81
88 84
88 63
60 78
73 66
84
85
85
84
59
62
91
83
80
76
Cherry GroBeechmont
1263 997
897 897 t-Test: Two-Sample Assuming Unequal Variances
849 912
891 895 Cherry Grove
964 785 Mean 1025
810 751 Variance 22500.296296
877 882 Observations 28
899 1110 Hypothesized Mean Difference 0
847 907 df 48
1070 1226 t Stat 2.9545828278
1252 762 P(T<=t) one-tail 0.0024195814
920 836 t Critical one-tail 1.6772241961
1256 1048 P(T<=t) two-tail 0.0048391628
1196 774 t Critical two-tail 2.0106347576
1150 807
1024 972
1016 980
1126 877
1289 943
1220 993
912 704
1026 963
786
989
1133
990
999
1049
Beechmont
910.0455
15624.14
22
Worker Method 1 Method 2
1 6 5.4 t-Test: Paired Two Sample for Means
2 5 5.2
3 7 6.5 Method 1
4 6.2 5.9 Mean 6.1
5 6 6 Variance 0.428
6 6.4 5.8 Observations 6
Pearson Correlation 0.8764236975
Hypothesized Mean Difference 0
df 5
t Stat 2.1957751641
P(T<=t) one-tail 0.0397579573
t Critical one-tail 2.0150483733
P(T<=t) two-tail 0.0795159146
t Critical two-tail 2.5705818356
Method 2
5.8
0.212
6
Math Scor Writing Sc di dbar
540 474 66 25
432 380 52 t-Test: Paired Two Sample for Means
528 463 65
574 612 -38
448 420 28 Mean
502 526 -24 Variance
480 430 50 Observations
499 459 40 Pearson Correlation
610 615 -5 Hypothesized Mean Difference
572 541 31 df
390 335 55 t Stat
593 613 -20 P(T<=t) one-tail
t Critical one-tail
P(T<=t) two-tail
t Critical two-tail
Math Score Writing Score
514 489
4661.2727273 8735.81818182
12 12
0.9421673622
0
11
2.3374293912
0.0196751379
1.7958848187
0.0393502759
2.2009851601
Day Evening
96670 118379
97855 111005
96368 100482
98465 122160
98550 117158
101623 101556
95753 98875
102036 104384
99475 110932
103780 101963
97608 123513
99859 102195
101764 111388
97287 116287
98066 119660
95390 112553
96125 98245
96767 98062
99494 101657
102498 106451
99260 104247
102020 105507
102468 118339
96543 109847
102491 123996
96557 122545
102627 113248
95048 104941
96969 111829
95103 114721
n 200
p 0.67
pbar 0.61 p-value
alpha 0.1

check the conditions


np 134
n(1-p) 66

z-value -1.804562
P(z<=-1.8) 0.035572
p-value 0.071143
0.99379 n 200
0.00621 x 122
p0 0.67
pbar 0.61

np 134
n(1-p) 66

z-score -1.804562
0.035572
p-value 0.071143
Company End of 1st Beginning di (di-dbar)sq
Bank of Ne 24.13 19.91 4.22 0.655452
Kraft Food 38.01 37.36 0.65 7.619808 n
Dupont 52.9 45.78 7.12 13.76113 dbar
Consolidat 58.42 62.03 -3.61 49.28602 Sd
Johnson & 65.96 65.58 0.38 9.183324 t-statistic
Union Pacif 107.48 105.94 1.54 3.498396
Comcast 30.01 23.71 6.3 8.349788 margin of error
Applied Ma 12.45 10.71 1.74 2.790236
Pfiser 43.41 41.22 2.19 1.489376
General Ele 20.07 17.91 2.16 1.5635 UL
AT&T 31.23 30.24 0.99 5.858336 LL
Cisco Syst 21.15 18.08 3.07 0.115872
Home Depo 50.31 42.04 8.27 23.61571
JP Morgan 45.98 33.25 12.73 86.85494
Procter & 67.21 66.71 0.5 8.470428 Sample mean
Verizon 38.23 40.12 -1.89 28.09424
Devon Ene 71.12 62 9.12 32.59953 LL %change
Lilly 40.27 41.56 -1.29 22.09376 UL %change
Microsoft 32.26 25.96 6.3 8.349788
Coco Cola 74.01 69.97 4.04 0.396396
Qualcomm 68.06 54.7 13.36 98.99454
Exxon Mobi 86.73 84.76 1.97 2.074752
Pacific Gas 22.65 21.64 1.01 5.76192
Oracle Sys 29.16 25.58 3.58 0.028764
Chevron 107.21 106.4 0.81 6.76208
25 t-Test: Paired Two Sample for Means
3.4104
4.224276 End of 1st Quarter
-2.063899 Mean 49.5368
Variance 683.023322666665
-1.743695 Observations 25
Pearson Correlation 0.987101295810183
Hypothesized Mean Difference 0
5.154095 df 24
1.666705 t Stat 4.03666847985063
P(T<=t) one-tail 0.000240129921041
t Critical one-tail 1.71088207990943
P(T<=t) two-tail 0.000480259842082
46.1264 t Critical two-tail 2.06389856162803

3.61%
11.17%
Beginning of Year
46.1264
695.847023999999
25
Milbank Gulf Park
35.9 21.6 F-Test Two-Sample for Variances
29.9 20.5
31.2 23.3 Milbank Gulf Park
16.2 18.8 Mean 20.230769231 20.24375
19 17.2 Variance 48.020615385 19.999958333
15.9 7.7 Observations 26 16
18.8 18.6 df 25 15
22.2 18.7 F 2.4010357714
19.9 20.4 P(F<=f) one-tail 0.0405270702
16.4 22.4 F Critical one-tail 2.2797292801
5 23.1
25.4 19.8
14.7 26
22.7 17.1
18 27.9
28.1 20.8
12.1
21.4
13.4
22.9
21
10.1
23
19.4
15.2
28.2
Beer DrinkPreferenceGender
1 Regular Male
2 Light Female Count of Preference Preference
3 Regular Male Gender Dark Light Regular
4 Regular Male Female 8 39 21
5 Regular Female Male 25 51 56
6 Regular Male Total Result 33 90 77
7 Dark Male
8 Dark Male Observed
9 Dark Male Count of Preference Column Labels
10 Light Female Row Labels Dark Light Regular
11 Light Male Female 8 39 21
12 Dark Female Male 25 51 56
13 Regular Male Grand Total 33 90 77
14 Regular Male
15 Light Male Expected
16 Regular Male Count of Preference Column Labels
17 Dark Male Row Labels Dark Light Regular
18 Regular Male Female 11.22 30.6 26.18
19 Light Female Male 21.78 59.4 50.82
20 Regular Female Grand Total 33 90 77
21 Regular Female
22 Light Male
23 Regular Male
24 Light Female
25 Light Male critical value 5.99146
26 Dark Male test statistic 6.44682
27 Light Male
28 Light Male df 2 (nrows-1)*(ncolumns-1)
29 Regular Male p-value 0.0398
30 Light Male
31 Light Male
32 Light Female
33 Regular Male
34 Dark Male
35 Regular Male
36 Regular Female
37 Regular Male
38 Dark Male
39 Regular Female
40 Dark Male
41 Light Female
42 Dark Female
43 Dark Male
44 Regular Female
45 Light Male
46 Light Male
47 Regular Male
48 Light Female
49 Light Male
50 Regular Male
51 Light Male
52 Light Male
53 Light Female
54 Regular Female
55 Light Male
56 Regular Male
57 Dark Male
58 Light Female
59 Light Male
60 Dark Male
61 Regular Male
62 Regular Male
63 Light Female
64 Dark Male
65 Light Male
66 Light Female
67 Regular Female
68 Light Male
69 Light Male
70 Regular Male
71 Light Male
72 Regular Male
73 Regular Male
74 Regular Male
75 Light Female
76 Dark Male
77 Regular Male
78 Light Female
79 Regular Male
80 Regular Male
81 Light Female
82 Light Female
83 Light Male
84 Regular Male
85 Light Male
86 Light Female
87 Light Male
88 Light Male
89 Regular Female
90 Regular Male
91 Regular Female
92 Light Male
93 Regular Male
94 Light Male
95 Light Male
96 Regular Male
97 Regular Male
98 Light Female
99 Light Female
100 Dark Male
101 Light Male
102 Regular Male
103 Dark Male
104 Light Female
105 Dark Male
106 Regular Male
107 Light Male
108 Light Male
109 Light Male
110 Regular Female
111 Regular Male
112 Regular Male
113 Light Male
114 Regular Male
115 Light Female
116 Dark Male
117 Light Female
118 Light Female
119 Regular Male
120 Light Female
121 Light Male
122 Light Female
123 Light Female
124 Light Male
125 Regular Female
126 Regular Male
127 Regular Male
128 Dark Male
129 Regular Male
130 Dark Female
131 Light Female
132 Dark Male
133 Dark Female
134 Light Male
135 Light Female
136 Light Female
137 Dark Female
138 Regular Male
139 Light Female
140 Dark Male
141 Dark Male
142 Light Male
143 Light Male
144 Light Male
145 Light Female
146 Light Male
147 Regular Female
148 Light Female
149 Light Female
150 Dark Male
151 Light Male
152 Light Female
153 Regular Female
154 Regular Male
155 Regular Female
156 Regular Female
157 Regular Male
158 Dark Male
159 Light Female
160 Regular Male
161 Regular Male
162 Light Male
163 Light Male
164 Light Male
165 Regular Male
166 Light Male
167 Dark Female
168 Dark Male
169 Regular Male
170 Light Female
171 Regular Female
172 Regular Male
173 Dark Female
174 Dark Female
175 Light Female
176 Regular Male
177 Light Female
178 Regular Male
179 Regular Male
180 Light Female
181 Regular Female
182 Regular Female
183 Regular Male
184 Light Male
185 Regular Male
186 Light Female
187 Regular Female
188 Regular Male
189 Regular Male
190 Regular Female
191 Dark Male
192 Light Male
193 Light Male
194 Regular Male
195 Light Male
196 Light Male
197 Regular Male
198 Light Male
199 Light Male
200 Light Male
Total Result
68
132
200

Grand Total
68
132
200

Grand Total
68
132
200

(nrows-1)*(ncolumns-1)
Method A Method B Method C
58 58 48 Anova: Single Factor
64 69 57
55 71 59 SUMMARY
66 64 47 Groups Count Sum Average
67 68 49 Method A 5 310 62
Method B 5 330 66
Method C 5 260 52

ANOVA
Source of Variation SS df MS
Between Groups 520 2 260
Within Groups 340 12 28.333333333

Total 860 14
t 2.178813

Variance LSD 7.334977


27.5
26.5
31

F P-value F crit
9.1764705882 0.0038184121 3.8852938347
Atlanta Dallas Seattle
85 71 59 Anova: Single Factor
75 75 64
82 73 62 SUMMARY
76 74 69 Groups Count Sum Average
71 69 75 Atlanta 6 474 79
85 82 67 Dallas 6 444 74
Seattle 6 396 66

ANOVA
Source of Variation SS df MS
Between Groups 516 2 258
Within Groups 430 15 28.666666667

Total 946 17
Variance
34
20
32

F P-value F crit
9 0.0027028995 3.6823203437
AssignmenMiles Deliveries Time miles* Deliveries*
1 100 4 9.3 0 2
2 50 3 4.8 -50 1
3 100 4 8.9 0 2
4 100 2 6.5 0 0
5 50 2 4.2 -50 0
6 80 2 6.2 -20 0
7 75 3 7.4 -25 1
8 65 4 6 -35 2
9 90 3 7.6 -10 1
10 90 2 6.1 -10 0
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9506781661
R Square 0.9037889755
Adjusted R Square 0.8763001113
Standard Error 0.5731421521
Observations 10

ANOVA
df SS MS F Significance F
Regression 2 21.60055651424 10.800278257 32.878367426 0.00027624024
Residual 7 2.299443485764 0.3284919265
Total 9 23.9

Coefficients Standard Error t Stat P-value Lower 95%


Intercept -0.8687014668 0.951547724666 -0.9129352572 0.391634304 -3.1187542931
Miles 0.0611345988 0.009888494576 6.1823969585 0.0004529608 0.03775202471
Deliveries 0.9234253667 0.221113460675 4.1762512507 0.004156622 0.40057511523
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9506781661
R Square 0.9037889755
Adjusted R Square 0.8763001113
Standard Error 0.5731421521
Observations 10

ANOVA
df
Regression 2
Residual 7
Total 9

Upper 95% Lower 90.0% Upper 90.0% Coefficients


1.3813513595 -2.6714834277 0.9340804941 Intercept 7.0916091458
0.0845171729 0.0424000685 0.0798691291 miles* 0.0611345988
1.4462756182 0.5045085348 1.3423421986 Deliveries* 0.9234253667
SS MS F Significance F
21.60055651424 10.800278257 32.878367426 0.00027624024
2.299443485764 0.3284919265
23.9

Standard Error t Stat P-value Lower 95% Upper 95% Lower 90.0% Upper 90.0%
0.352587833833 20.113028486 1.880394E-07 6.25787140312 7.9253468885 6.4236037794 7.7596145122
0.009888494576 6.1823969585 0.0004529608 0.03775202471 0.0845171729 0.0424000685 0.0798691291
0.221113460675 4.1762512507 0.004156622 0.40057511523 1.4462756182 0.5045085348 1.3423421986

You might also like