Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Engineers are testing company fleet vehicle fuel economy (miles per gallon) perf

ID: 3378399 • Letter: E

Question

Engineers are testing company fleet vehicle fuel economy (miles per gallon) performance by using different types of fuel. One vehicle of each size is tested. Does this sample provide sufficient evidence to conclude that there is a significant difference in treatment means?

   

      

    

Engineers are testing company fleet vehicle fuel economy (miles per gallon) performance by using different types of fuel. One vehicle of each size is tested. Does this sample provide sufficient evidence to conclude that there is a significant difference in treatment means?

Explanation / Answer

The analysis has been performed using the MS-EXCEL addin data analysis. The results are as follows.

Anova: Two-Factor Without Replication SUMMARY Count Sum Average Variance   Compact 5 136.6 27.32 23.167   Mid-Size 5 103 20.6 40.785   Full-Size 5 138.2 27.64 13.898   SUV 5 111.6 22.32 16.427 87 Octane 4 98.6 24.65 34.07 89 Octane 4 98.4 24.6 25.02 91 Octane 4 76.5 19.125 2.5025 Ethanol 5% 4 96.4 24.1 46.00666667 Ethanol 10% 4 119.5 29.875 3.7625 ANOVA Source of Variation SS df MS F P-value F crit Rows 188.854 3 62.951 5.20 0.0157 3.49 Columns 231.877 4 57.969 4.79 0.0153 3.26 Error 145.231 12 12.103 Total 565.962 19