13.5 Excel Activity 1b - ANOVA, Factorial Experiment (Freeform)

Please see attached for data

As part of a study designed to compare hybrid and similarly equipped conventional vehicles, a variety of classes of hybrid and all-gas model cars and sport utility vehicles (SUVs) were tested. The data showing the miles-per-gallon rating study obtained for two hybrid small cars, two hybrid midsize cars, two hybrid small SUVs, two hybrid midsize SUVs, and eight similarly equipped conventional models are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.

13.5 Excel Activity 1b - ANOVA, Factorial Experiment (Freeform) Question 1 C LACEI VIIIIIIC THIS WEIVVV. 0/10 Construct a spreadsheet to answer the following questions. Submit X Open spreadsheet a. At the a = .05 level of significance, test for significant effects due to class, type, and interaction. Source Sum of Squares Degrees Mean Square F of Variation (to 2 decimals) of Freedom (to 2 decimals) (to 2 decimals) Class Type Interaction Error Total b. The p-value for the class of vehicle is What is your conclusion with respect to the class of vehicle? There is v evidence to conclude that the fuel efficiency is not the same for the four classes of vehicle. c. The p-value for the type of vehicle is What is your conclusion with respect to the type of vehicle? There is evidence to conclude that the fuel efficiency is not the same for the two types of vehicle. d. The p-value for the interaction between class and type of vehicle is What is your conclusion with respect to the interaction between class and type of vehicle? The interaction between type and class of vehicle statistically significant. Check My Work Reset ProblemV Arial 10 V B V A . . . E1 v X V fx A B C D E F 1 Make/Model Class Type MPG 2 Honda Civic Small Car Hybrid 36 3 Honda Civic Small Car Conventional 28 4 Toyota Prius Small Car Hybrid 43 5 Toyota Corolla Small Car Conventional 32 6 Chevrolet Malibu Midsize Car Hybrid 28 7 Chevrolet Malibu Midsize Car Conventional 23 8 Nissan Altima Midsize Car Hybrid 31 9 Nissan Altima Midsize Car Conventional 26 10 Ford Escape Small SUV Hybrid 27 11 Ford Escape Small SUV Conventional 21 12 Saturn Vue Small SUV Hybrid 27 13 Saturn Vue Small SUV Conventional 23 Lexus RX Midsize SUV Hybrid 22 15 Lexus RX Midsize SUV Conventional 19 16 Toyota Highlander Midsize SUV Hybrid 23 17 Toyota Highlander Midsize SUV Conventional 19 18 19 20