Homework answers / question archive / The average mpg usage for a 2017 Toyota Prius for a sample of 10 tanks of gas was 45

The average mpg usage for a 2017 Toyota Prius for a sample of 10 tanks of gas was 45

Math

Share With

The average mpg usage for a 2017 Toyota Prius for a sample of 10 tanks of gas was 45.5 with a standard deviation of 1.8. For a 2017 Ford Fusion, the average mpg usage for a sample of 10 tanks of gas was 42.0 with a standard deviation of 2.3. Assume equal variances and α = .01, is the true mean mpg lower for the Ford Fusion?

This is correct. Ho: μtoy - μford ≤ 0 vs. Ha: μtoy - μford > 0.

Q. What is the value of your calculated t test statistic? (Please show how to get the answer and value to 3 decimals)

Q. Based on your hypothesis test, is the true mean mpg lower for the Ford Fusion? (Yes, or No ?)

Q. Calculate the p-value using Excel. (Please show value and how to calculate in excel.)