2) Engineers are testing company fleet vehicle fuel economy (miles per gallon) p
ID: 3204112 • Letter: 2
Question
2) Engineers are testing company fleet vehicle fuel economy (miles per gallon) performance. They classify vehicles by class (Compact, Mid-Size, Full-size and SUV) and use five different types of fuel (87 Octane, 89 Octane, 91 Octane, Ethanol 5% and Ethonal 10%).
a) State the Hypotheses to show fuel economy depends on vehicle class and fuel type.
b) Choose a level of Use = 0.05 for this problem.
c) To test the hypotheses, the engineers test vehicles of each of the 4 sizes using each of the five fuel types. The data appear in the MPG2 worksheet in the HW5 data workbook on Moodle. Test the hypotheses using Excel.
d) Draw a conclusion and report that in the context of the problem.
Vehicle Size 87 Octane 89 Octane 91 Octane Ethanol 5% Ethanol 10% Compact 27.2 30 30.3 26.8 25.8 Mid-Size 23 25.6 28.6 26.6 23.3 Full-Size 21.4 22.5 22.2 18.9 20.8 SUV 18.7 24.1 22.1 18.7 17.4Explanation / Answer
a. Vehicle size is blocking factor and fuel type is the treatment.
Rows ( Vehicle Size)
H0: A1=A2=A3=A4 = 0
H1 : Not all the Ai are equal to zero.
Columns ( Fuel type)
H0 : B1=B2=B3=B4=0
H1: Not all the Bk are equal to zero.
By using excel we can solve this question easily.
First enter all data in excel.
Click on Data -------> Data Analysis--------> Anova: Two-Factor Without Replication-----> Input Data -------> Select all data -------> Output Range : Select any empty cell --------> ok
We get ANOVA
The p-value corresponding to Row is 3.51E-06 which is less than .05 so we reject null hypothesis.
Conclusion : At least on Aj are equal to zero.
The p-value corresponding to Row is 0.003917 which is less than .05 so we reject null hypothesis.
Conclusion : At least on Bk are equal to zero.
ANOVA Source of Variation SS df MS F P-value F crit Rows 201.612 3 67.204 34.51817 3.51E-06 3.490295 Columns 54.065 4 13.51625 6.942388 0.003917 3.259167 Error 23.363 12 1.946917 Total 279.04 19Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.