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. Excel template - SavedFile5G18123456789HomeAMake/ModelHonda CivicHonda CivicToyota PriusToyota CorollaChevrolet MalibuChevrolet MalibuNissan AltimaNissan AltimaFord EscapeFord EscapeSaturn VueSaturn Vue1011121314Lexus RX15 Lexus RX16 Toyota Highlander17 Toyota Highlander181920212223242526272829303132333425InsertArialX ✓ fxBDraw Page Layout✓10сClassTypeSmall Car HybridSmall Car ConventionalSmall Car HybridSmall Car ConventionalMidsize Car HybridMidsize Car ConventionalMidsize Car HybridMidsize Car ConventionalSmall SUV HybridSmall SUV ConventionalSmall SUV HybridSmall SUV ConventionalMidsize SUV HybridMidsize SUV ConventionalMidsize SUV HybridMidsize SUV ConventionalData Sheet2 Sheet3 +Calculation Mode: Automatic Workbook StatisticsBDMPG38284432282433262820272223182518FormulasESearch (Option + Q)DataAReviewSmall CarMidsize CarSmall SUVViewMidsize SUVVabFGHIRearrange the data for the Anova: Two-Factor With Replication AnalysisHybridHelpGeneral←.0.00Conventional.00→.0KLAfter reading these instructions delete all text in this shaded area.Use the XLMiner Analysis ToolPak to conduct your Anova: Two-Factor With Replication analysis.After deleting all text in this shaped area, set the output range in the ToolPak to the top left cellof this area (F14).Your Anova analysis output should fit into this shaded area.MNEditingΣ ✓ POOvPGive Feedback to MicrosoftComments|Q100% + XOpen spreadsheeta. At the a = .05 level of significance, test for significant effects due to class, type, and interaction.Sourceof VariationClassТуреInteractionErrorTotalThere isb. The p-value for the class of vehicle isWhat is your conclusion with respect to the class of vehicle?Sum of Squares(to 2 decimals)There isDegreesof Freedomc. The p-value for the type of vehicle isWhat is your conclusion with respect to the type of vehicle?Check My Workevidence to conclude that the fuel efficiency is not the same for the four classes of vehicle.Mean SquareF(to 2 decimals) (to 2 decimals)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 isWhat is your conclusion with respect to the interaction between class and type of vehicle?The interaction between type and class of vehiclestatistically significant.Reset ProblemGo

Question

Accepted Answer

Make/ModelClassTypeMPGHonda CivicSmall CarHybrid38Honda CivicSmall CarConventional28Toyota…