In: Statistics and Probability
Suppose the weights of tight ends in a football league are normally distributed such that σ2=1,369. A sample of 49 tight ends was randomly selected, and the weights are given below. Use Excel to calculate the 95% confidence interval for the mean weight of all tight ends in this league. Round your answers to two decimal places and use ascending order.
Weight
300
294
155
270
218
242
150
364
298
167
297
299
221
266
261
301
269
267
219
165
198
359
240
263
160
171
169
259
196
197
268
271
200
295
258
199
260
303
264
241
220
265
262
343
321
302
364
296
170
Here population variance is known so we can use z-method to obtained the confidence interval for population mean.
The formula of confidence interval for the population mean is as follow:
Where E is the margin of error.
Let's use excel:
The formulae used on the above excel-sheet are as follows: