310homework4data2.xlsx

1

P(T10>=1.75) 0.9446595279
P(T100>=1.75) 0.958407154
P(z>=1.75) 0.9599408431
P(T20<=-0.8) 0.7834445609
P(T3<=-0.8) 0.7589005241
p(-0.8<=z<=1.75) 0.7480854446
p(t10>x)=0.75 0.6998120613
p(t100>x)=0.75 0.676951043
P(Z>z)=0.75 0.6744897502

#3

Observation John Fred
1 66.4 75.6 John Fred
2 63.8 75.1 alpha 0.05 alpha 0.05
3 69.3 74.6 Sample mean 65.8 Sample mean 67.1
4 64.2 76.1 sample size 70 sample size 70
5 55.7 71.6 Degree of freedom 69 Degree of freedom 69
6 72.5 73.7 T-score 1.9949454151 T-score 1.9949454151
7 66.2 75.8 Sample STDEV 4.0220973485 Sample STDEV 6.0734844406
8 64.0 81.8 Sample Error 0.480732582 Sample Error 0.7259202362
9 68.3 73.3 Margin of error 0.9590352604 Margin of error 1.4481712469
10 66.1 73 Lower Bound 64.9 Lower Bound 65.7
11 64.3 77.8 Upper Bound 66.8 Upper Bound 68.6
12 67.1 74.8 confidence interval (64.9,66.8) confidence interval (65.7,68.6)
13 70.1 61.3
14 65.7 69.7
15 63.0 68.7
16 59.0 76.1
17 59.1 77.7
18 65.9 71
19 67.8 71.6
20 77.0 62.3
21 65.4 66.4
22 70.5 78.3
23 65.2 70.9
24 73.3 70
25 63.2 70.9
26 65.6 70
27 63.2 66.5
28 62.7 71.9
29 61.1 67.8
30 65.2 70.1
31 64.6 72.1
32 70.0 70.7
33 65.8 60.3
34 68.2 65.7
35 70.2 68.6
36 68.8 70.4
37 58.5 61.4
38 63.8 62.7
39 64.0 64
40 68.5 69.5
41 69.0 62.3
42 56.8 66.1
43 64.8 62.1
44 60.1 68
45 66.8 60.6
46 73.0 64.7
47 66.0 60.6
48 62.5 62.3
49 69.7 59.1
50 65.8 60.8
51 65.2 68
52 69.6 61.6
53 64.8 58.3
54 70.5 55.8
55 61.3 67.8
56 65.8 64.1
57 67.9 63.9
58 68.8 60.2
59 64.1 62.3
60 60.5 61.1
61 63.6 63.4
62 67.6 64.5
63 66.4 58.5
64 64.1 60.1
65 72.1 62.9
66 66.6 57.2
67 66.0 63.5
68 71.9 65.7
69 65.6 64.7
70 58.8 57.4

#4

Customer Time
1 138.6 Confidence level 0.95
2 43.3 alpha 0.05
3 57.5 Sample mean 97.2
4 84.2 Sample STDEV 67.3410925418
5 44.7 sample size 200
6 30.4 degree of freedom 199
7 317.6 T score 1.9719565443
8 82.4 Sample error 4.7617343189
9 67.0 Margin of error 9.3899331521
10 84.6 Lower Bound 87.8
11 71.0 Upper Bound 106.6
12 39.2 confidence interval (87.8,106.6)
13 68.7
14 40.2
15 44.2
16 73.0
17 37.7
18 54.4
19 94.4
20 38.8
21 129.5
22 51.1
23 45.6
24 114.5
25 91.3
26 94.8
27 94.7
28 102.3
29 31.1
30 40.0
31 38.8
32 90.9
33 32.1
34 35.6
35 198.5
36 96.6
37 115.2
38 110.7
39 181.6
40 60.6
41 143.5
42 50.3
43 111.9
44 79.1
45 65.9
46 178.1
47 96.2
48 38.4
49 141.0
50 63.0
51 47.2
52 44.5
53 248.8
54 34.5
55 44.8
56 30.9
57 133.4
58 41.2
59 34.8
60 30.7
61 269.5
62 64.3
63 171.8
64 51.2
65 117.5
66 41.6
67 96.7
68 58.6
69 49.1
70 58.2
71 43.1
72 134.1
73 149.8
74 120.5
75 32.2
76 128.3
77 113.7
78 154.9
79 68.0
80 52.5
81 63.5
82 40.7
83 164.9
84 211.1
85 225.8
86 162.0
87 163.5
88 79.3
89 52.5
90 84.6
91 72.2
92 69.8
93 89.3
94 365.4
95 35.9
96 96.9
97 62.4
98 79.5
99 152.0
100 212.1
101 152.8
102 87.6
103 188.4
104 67.0
105 122.8
106 158.1
107 138.9
108 155.0
109 91.6
110 194.2
111 74.8
112 269.4
113 30.4
114 112.0
115 67.3
116 210.2
117 97.6
118 71.5
119 39.3
120 30.7
121 68.5
122 45.0
123 132.6
124 91.2
125 60.1
126 90.6
127 81.2
128 58.2
129 40.9
130 46.8
131 45.5
132 88.6
133 40.0
134 165.7
135 56.7
136 49.8
137 230.4
138 41.5
139 70.6
140 37.2
141 107.1
142 75.2
143 197.8
144 50.2
145 77.1
146 85.6
147 167.9
148 86.5
149 40.5
150 66.0
151 46.7
152 49.9
153 175.1
154 193.7
155 34.1
156 119.5
157 72.3
158 183.8
159 31.1
160 166.9
161 126.9
162 190.1
163 120.0
164 38.3
165 35.2
166 100.4
167 70.8
168 102.3
169 101.7
170 54.9
171 123.5
172 43.8
173 66.4
174 38.0
175 144.4
176 37.6
177 68.3
178 88.8
179 132.3
180 112.4
181 52.5
182 42.7
183 85.0
184 92.7
185 90.8
186 256.0
187 50.0
188 226.1
189 113.8
190 41.1
191 77.1
192 517.7
193 112.0
194 76.3
195 73.2
196 88.4
197 198.4
198 36.9
199 47.6
200 50.7