Question

Are:

4. Suppose that the distance of fly balls hit to the outfield (in baseball) is normally
distributed. We randomly sample 27 fly balls. Their recorded distances in feet
234, 310, 285, 249, 210, 311, 265, 290, 308,
254, 295, 287, 231, 302, 325, 308, 221, 237,
312, 277, 259, 223, 340, 204, 214, 303, 309
Let X be the distance of a fly ball.
Use Excel to calculate the following:
a. (1 pt) mean of the sample, x =
b. (1 pt) standard deviation of the sample, s =
C. (2 pts) Calculate the t-score at a 96% confidence level:
d. (2 pts) Calculate the Error Bound (EBM), using the formula, EBM =
(t)(s//n)
e. (1 pt) At 96% confidence level, provide the confidence interval (CI) for the
mean distance in feet of a fly ball.
hantor 92
D​

Answer 1

Explanation:

a. The mean can be found using the AVERAGE() function.

x = 272.7

b. The standard deviation can be found with the STDEV() function.

s = 39.9

c. The t-score can be found with the T.INV.2T() function. The confidence level is 0.04, and the degrees of freedom is 26.

t = 2.162

d. Find the lower and upper ends of the confidence interval.

Lower = 272.7 − 2.162 × 39.9 = 186.5

Upper = 272.7 + 2.162 × 39.9 = 358.9