Homework SourseEngineers are testing company fleet vehicle fuel economy mil
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? |
Solution
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 |
