Question text
7-stepHypothesis Testing Problem
Complete the 7steps in Excel and upload the file here
Two major automobilemanufacturers have produced compact cars with the same sizeengines.We are interested in determining whether or not there is asignificant difference in the MPG (miles per gallon) of the twobrands of automobiles.A random sample of eight cars from eachmanufacturer is selected, and eight drivers are selected to driveeach automobile for a specified distance.The following data showthe results of the test.
Driver | Manufacturer A | Manufacturer B |
1 | 32 | 28 |
2 | 27 | 22 |
3 | 26 | 27 |
4 | 26 | 24 |
5 | 25 | 24 |
6 | 29 | 25 |
7 | 31 | 28 |
8 | 25 | 27 |
At the 0.05 level ofsignificance, conduct a 7-step hypothesis test to determine whetherthere is a significant difference in the MPG (miles per gallon) ofthe two brands of automobiles.