A type of golf ball is tested by dropping it onto a hard surface from a height of 1 meter. The height it bounces is known to be normally distributed. A sample of 25 balls is tested and the bounce heights are given below. Use Excel to find a 95% confidence interval for the mean bounce height of the golf ball. Round your answers to two decimal places and use increasing order.
Height
81.4
80.8
84.4
85.6
82.9
76.0
80.0
83.2
80.8
79.6
82.9
83.4
82.2
86.0
76.2
84.8
82.0
76.3
77.0
75.4
82.0
79.8
80.4
86.9
82.1

Respuesta :

Answer:

79.95, 82.62

Step-by-step explanation:

using excel to find a 95% confidence interval for the mean bounce height of the golf ball

Heights given are :

81.4

80.8

84.4

85.6

82.9

76.0

80.0

83.2

80.8

79.6

82.9

83.4

82.2

86.0

76.2

84.8

82.0

76.3

77.0

75.4

82.0

79.8

80.4

86.9

82.1

The statistical out put of the problem after solving with excel is attached below

therefore the 95% confidence interval from the attached solution will be ( 79.95, 82.62 )

Ver imagen batolisis