Confidence Intervals - Demonstration.xlsx - 1 2 3 4 5 6 7 8...

100 StDev = 10 alpha = 0.05 Sample Mean
1 118.7 121.6 100.2 94.6 106.8 83.8
2 93.5 95.9 94.4 96.4 82.4 89.7
3 107.1 97.7 105.3 100.2 104.8 100.3
4 106.1 87.3 97.7 123.9 109.0 102.3
5 102.6 89.9 98.7 100.7 106.2 87.5
6 79.3 89.9 111.2 95.9 86.9 109.1
7 115.7 87.3 97.7 89.8 92.2 111.0
8 105.9 92.6 92.7 93.6 102.5 87.1
9 98.7 115.2 93.5 100.4 101.7 107.5
10 117.2 83.7 92.3 85.2 87.3 114.5
11 114.3 88.1 111.1 97.9 104.3 115.5
12 113.3 107.1 93.7 100.1 116.0 97.5
13 112.4 106.7 104.6 105.9 94.2 100.7
14 106.3 98.9 109.3 94.4 121.2 92.6
15 119.1 83.6 101.4 91.1 90.5 93.3
16 99.8 105.0 103.2 103.7 97.7 105.6
17 100.5 107.1 84.7 124.4 87.7 106.7
18 88.9 99.9 110.6 95.7 97.9 86.4
19 90.7 112.5 96.1 93.0 108.8 101.9
20 87.4 97.8 93.2 119.1 105.1 97.3
21 94.2 99.0 90.4 113.1 122.3 97.5
22 95.3 106.5 114.4 85.1 95.1 98.6
23 101.0 111.9 86.6 109.4 79.4 114.8
24 92.5 106.7 96.5 82.2 87.1 107.4
25 97.7 105.3 95.3 112.6 114.5 99.1
26 114.0 103.2 98.5 97.6 110.3 86.2
27 93.6 110.3 100.7 94.3 103.1 109.6
28 99.8 102.2 99.9 105.5 96.3 98.5
29 112.5 106.2 111.8 116.1 112.5 100.8
30 112.1 88.5 93.9 86.4 110.0 96.1
31 96.1 96.3 101.1 90.0 119.2 87.5
32 109.2 95.8 107.1 86.8 111.2 88.7
33 107.9 82.4 100.6 104.2 101.1 98.3
34 98.2 95.1 112.0 90.9 92.1 114.4
35 95.9 99.4 110.4 106.4 91.0 112.5
36 102.9 108.5 112.9 106.2 94.4 102.6
37 102.6 94.5 96.4 82.8 87.8 102.7
38 90.1 103.6 104.0 114.1 102.6 104.2
39 92.0 103.3 111.9 106.2 102.7 113.4
40 105.5 101.4 98.0 99.4 80.2 105.7
41 84.0 91.6 88.9 102.8 108.9 104.4
42 116.8 105.0 100.3 100.4 88.0 99.4
43 103.9 99.9 119.3 89.6 124.3 97.6
44 100.4 104.6 104.2 95.9 102.3 109.1
True but
"unknown"
value of
Mean =

45 110.4 106.3 87.0 96.5 89.6 96.0
46 117.3 92.5 110.7 72.5 81.8 109.3
47 104.1 107.8 99.7 95.3 103.1 103.2
48 99.1 101.5 110.0 106.4 103.4 93.1
49 103.2 114.7 114.2 76.4 88.6 121.9
50 100.6 83.1 108.0 84.8 101.9 120.1
51 114.6 93.4 106.3 120.2 109.7 81.4
52 92.6 109.0 87.0 98.6 102.4 117.8
53 95.9 105.9 100.5 98.8 107.6 86.9
54 88.8 91.5 122.0 97.6 112.8 99.0
55 112.0 88.6 97.9 98.3 108.7 94.4
56 95.8 92.5 97.1 104.2 104.4 107.8
57 89.0 106.6 102.0 105.6 88.6 111.6
58 108.8 102.4 111.9 93.2 112.3 97.8
59 100.0 105.5 104.2 97.9 89.6 102.3
60 86.7 109.6 97.2 120.2 99.8 102.0
61 88.8 102.4 127.2 94.1 101.2 100.2
62 103.9 101.1 108.7 102.4 105.3 100.0
63 88.6 113.8 102.4 113.0 103.5 102.2
64 102.9 107.7 90.3 91.2 103.9 108.9
65 103.0 97.6 107.7 81.7 93.9 90.9
66 111.6 109.6 90.7 89.4 101.4 99.4
67 85.9 99.6 96.2 95.3 109.3 85.0
68 84.1 93.1 112.6 98.9 105.2 102.7
69 98.1 96.6 110.2 113.5 104.4 80.8
70 106.2 106.8 98.4 70.9 102.5 112.8
71 108.4 108.0 112.5 111.9 96.2 105.9
72 100.8 79.2 120.3 103.3 81.6 97.7
73 97.6 111.9 104.4 107.0 96.4 95.2
74 103.8 81.5 91.7 104.7 101.8 100.9
75 115.3 116.0 117.9 85.2 107.0 92.4
76 95.9 109.1 99.3 107.9 115.2 81.5
77 101.8 85.1 97.4 85.3 100.5 95.5
78 108.2 99.7 123.2 116.1 121.7 100.2
79 107.3 104.5 113.3 102.3 75.2 99.0
80 100.8 98.4 101.0 106.0 79.7 102.6
81 86.3 109.6 93.2 98.4 97.9 80.5
82 95.8 110.4 87.8 88.2 122.4 96.2
83 101.4 98.6 92.9 101.4 86.2 103.0
84 108.8 96.8 99.3 112.2 108.8 101.7
85 92.4 104.1 90.2 125.0 99.0 86.3
86 117.4 119.0 89.7 106.2 87.0 105.5
87 102.4 97.5 96.8 109.9 75.3 80.4
88 86.5 89.5 87.4 103.7 87.6 99.2
89 104.9 92.0 96.5 109.2 113.6 95.8
90 91.6 94.4 85.7 106.5 89.2 103.6
91 108.4 100.6 113.2 91.4 79.1 104.1
92 86.6 100.8 108.1 110.4 95.5 115.7
93 102.4 96.6 90.5 97.3 108.5 97.7
94 104.1 127.0 99.0 125.6 97.6 106.3

95 99.3 102.8 99.3 113.9 105.7 93.0
96 91.5 101.2 107.0 110.7 99.9 96.2
97 108.7 90.3 87.9 95.8 101.4 88.9
98 111.5 83.8 94.5 106.2 80.7 105.4
99 103.4 100.8 99.9 109.8 96.3 102.2
100 100.5 115.4 104.4 113.0 104.1 95.3
101 107.3 100.0 100.7 94.5 95.7 94.7
102 96.7 114.6 111.0 93.9 111.6 90.0
103 114.7 94.9 105.3 97.4 89.0 124.7
104 104.5 97.8 106.9 102.8 90.6 103.8
105 86.0 98.2 88.0 110.1 115.8 98.3
106 102.5 108.3 113.6 115.8 89.2 103.1
107 85.8 83.9 82.9 94.6 117.3 99.6
108 104.4 94.0 90.8 113.9 92.6 81.7
109 80.7 107.6 101.7 94.5 102.4 106.6
110 115.2 93.3 107.1 110.1 89.2 109.0
111 105.3 109.2 98.5 84.0 81.2 87.6
112 117.7 104.9 105.3 117.8 97.9 94.1
113 112.5 88.8 95.7 96.2 120.0 98.5
114 83.1 90.2 119.8 92.5 95.7 100.3
115 107.0 101.6 103.6 107.3 85.3 99.1
116 92.0 88.1 116.2 90.7 109.4 95.0
117 106.6 96.3 119.8 102.6 95.7 113.5
118 89.8 106.1 100.8 79.1 108.1 106.8
119 88.3 111.9 104.4 127.9 118.1 106.1
120 99.3 101.3 90.2 90.6 109.8 108.0
121 94.6 100.8 98.3 94.4 110.6 91.7
122 111.2 102.4 118.8 106.6 99.8 97.9
123 113.4 108.7 100.4 89.1 91.4 99.2
124 97.5 104.2 107.4 102.6 91.9 119.8
125 105.2 97.5 87.1 105.2 88.8 104.2
126 116.3 91.5 102.7 100.8 109.6 104.4
127 90.9 88.6 80.8 88.7 99.6 109.8
128 106.8 98.9 73.9 124.2 95.1 99.7
129 101.1 104.4 115.3 96.1 102.8 107.7
130 95.8 105.7 75.1 99.2 103.3 111.3
131 91.2 104.3 92.4 99.5 95.5 87.7
132 102.8 107.1 94.1 111.0 95.0 121.1
133 99.9 117.1 117.7 99.1 93.8 70.5
134 100.3 110.3 104.6 109.6 118.6 101.9
135 105.3 107.8 101.5 110.4 101.6 108.5
136 89.5 101.8 89.7 96.7 101.2 107.9
137 114.5 109.3 112.0 103.6 106.4 103.9
138 99.7 91.4 95.1 118.3 106.6 97.9
139 100.8 96.3 108.4 122.1 103.2 100.5
140 112.6 99.1 108.0 91.1 96.6 102.3
141 101.2 118.3 99.2 96.7 94.7 100.8
142 89.9 110.8 107.3 86.1 104.7 98.9
143 101.9 97.0 97.0 107.5 101.5 98.0
144 98.1 87.1 79.7 106.4 106.8 92.7

145 90.6 99.3 97.5 89.9 99.6 100.0
146 104.9 100.4 111.4 101.6 89.8 104.2
147 105.7 112.7 104.0 106.5 93.9 109.9
148 103.4 97.8 102.1 122.9 100.7 112.3
149 92.6 97.9 112.6 101.2 84.5 111.8
150 97.6 107.0 102.5 75.6 88.3 113.1
151 100.9 107.4 98.8 107.4 82.3 102.4
152 104.0 104.6 80.6 92.9 110.4 99.6
153 91.6 106.0 86.4 108.7 105.2 88.8
154 108.9 95.8 86.8 101.5 89.1 106.7
155 121.7 79.7 96.0 92.8 100.1 91.3
156 107.5 117.9 104.5 95.2 102.0 105.3
157 103.7 110.7 87.8 91.5 97.2 108.3
158 111.5 90.5 89.3 109.4 103.5 100.1
159 107.1 110.2 97.5 106.5 85.8 92.2
160 102.5 124.5 102.3 98.0 95.0 99.1
161 98.6 83.8 98.9 111.1 105.3 111.8
162 102.3 78.0 95.1 101.8 83.5 86.2
163 100.2 93.0 116.1 100.1 94.4 98.4
164 106.4 116.0 111.4 82.6 113.2 101.7
165 95.5 94.2 109.7 113.6 115.6 102.6
166 108.2 91.0 76.6 93.3 98.5 95.8
167 98.6 92.5 85.3 109.7 95.3 93.6
168 102.9 111.3 101.0 101.6 94.3 96.0
169 107.3 94.8 95.7 86.3 91.5 84.4
170 97.7 86.3 91.5 96.5 104.2 87.8
171 84.4 104.8 88.7 107.1 73.6 101.3
172 87.7 99.9 109.4 96.7 107.0 106.3
173 91.8 119.8 115.5 98.4 125.7 105.5
174 112.8 112.5 108.1 103.9 107.4 105.4
175 97.5 84.0 104.2 123.8 103.5 84.6
176 111.5 114.3 98.7 107.2 95.6 99.0
177 104.5 94.2 96.2 85.7 109.7 85.0
178 103.1 102.7 102.3 85.2 80.7 98.3
179 100.3 110.9 107.5 109.0 103.9 94.7
180 101.5 83.9 110.2 87.9 95.7 108.0
181 114.6 96.7 108.1 113.4 106.6 104.1
182 79.1 104.2 92.7 82.0 108.6 111.2
183 100.4 104.2 129.5 114.9 92.9 97.3
184 107.0 110.2 103.9 85.3 96.2 89.2
185 98.3 93.1 84.6 100.3 102.4 89.2
186 107.1 95.6 101.8 99.1 101.8 118.6
187 99.4 102.9 88.3 98.6 116.8 100.9
188 89.9 96.9 102.8 111.2 91.8 106.5
189 94.6 101.8 113.0 104.3 105.8 91.7
190 115.8 109.7 104.3 104.6 91.6 90.9
191 94.3 118.6 99.1 116.7 90.9 95.3
192 98.0 108.1 111.4 105.3 102.9 74.6
193 95.8 105.3 125.2 105.1 103.6 83.7
194 87.9 78.6 114.1 101.8 100.5 90.2

195 93.8 109.5 94.7 83.7 100.4 93.9
196 108.6 106.0 100.3 95.8 83.2 90.6
197 91.8 96.9 86.3 85.9 113.4 92.5
198 94.2 97.6 108.4 94.8 89.7 76.3
199 106.0 81.5 116.9 99.0 75.5 91.0
200 109.1 101.0 85.3 82.9 92.6 109.1
201 104.4 120.1 113.6 96.7 111.3 93.2
202 108.8 119.5 103.4 100.8 117.7 92.3
203 99.1 82.2 97.9 96.3 114.8 99.1
204 86.8 92.0 98.3 108.1 101.8 93.2
205 91.4 100.4 82.9 105.2 93.6 89.6
206 97.3 97.6 85.2 105.8 100.9 103.6
207 87.2 108.6 91.4 104.5 95.7 96.5
208 82.4 104.1 101.0 88.4 121.3 106.9
209 80.8 87.9 93.6 106.5 92.0 110.7
210 81.0 87.0 108.1 100.2 107.9 83.0