An automotive company used two different drivers to test the fuel economy of its latest crossover model. Each driver tested the same 20 vehicles from the factory. When the supervisor reviewed the data, she thought it looked like Driver A had different fuel economies than Driver B on average for the different vehicles and decided to test the data. To test the data, she first separated the data into pairs, with each car tested as a pair. The data is given below, with the fuel economy for each car given in miles per gallon. Assume that both populations are normally distributed. Use Excel to test if the true mean difference between Driver A and Driver B is significantly different from zero, where α=0.05, where each difference is calculated as Driver A−Driver B. Identify the t-test statistic, rounding to two decimal places, and the p-value, rounding to three decimal places. Pair DriverA DriverB 3 35 31 4 33 35 5 20 22 6 37 34 7 43 39 8 24 21 9 34 32 10 22 24 11 35 34 12 24 26 13 40 36
An automotive company used two different drivers to test the fuel economy of its latest crossover model. Each driver tested the same 20 vehicles from the factory. When the supervisor reviewed the data, she thought it looked like Driver A had different fuel economies than Driver B on average for the different vehicles and decided to test the data. To test the data, she first separated the data into pairs, with each car tested as a pair. The data is given below, with the fuel economy for each car given in miles per gallon. Assume that both populations are
Use Excel to test if the true mean difference between Driver A and Driver B is significantly different from zero, where α=0.05, where each difference is calculated as Driver A−Driver B. Identify the t-test statistic, rounding to two decimal places, and the p-value, rounding to three decimal places.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images