Using EXCEL, develop a 95% confidence Interval estimate for the Mean number of miles driven until the transmission failure for the population of GM automobiles that had a transmission failure. What is your interpretation of this “Interval Estimate”?
GM is interested is interested in learning more about customer satisfaction with the performance of one of their automobiles. Several customers appear to be unhappy and have complained about early transmission failures. To learn more about this problem, GM wants to estimate the “Average Miles driven” before the failure occurred. For this GM used a random sample of actual transmission repairs on cars from their domestic dealerships. Following data (sent to you as a separate EXCEL file via e-mail) shows the actual number of miles driven at the time of transmission failure for 50 randomly chosen vehicles.
|
85,092 |
32,609 |
59,465 |
77,437 |
32,534 |
64,090 |
32,464 |
59,902 |
|
39,323 |
89,641 |
94,219 |
116,803 |
92,857 |
63,436 |
65,605 |
85,861 |
|
64,342 |
61,978 |
67,998 |
59,817 |
101,769 |
95,774 |
121,352 |
69,568 |
|
74,276 |
66,998 |
40,001 |
72,069 |
25,066 |
77,098 |
69,922 |
35,662 |
|
74,425 |
67,202 |
118,444 |
53,500 |
79,294 |
64,544 |
86,813 |
116,269 |
|
37,831 |
89,341 |
73,341 |
85,288 |
138,114 |
53,402 |
85,586 |
82,256 |
|
77,539 |
88,798 |
|
|
|
|
|
|
- Using EXCEL, develop a 95% confidence
Interval estimate for theMean number of miles driven until the transmission failure for the population of GM automobiles that had a transmission failure. What is your interpretation of this “Interval Estimate”?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
