(Solved): As part of a study designed to compare hybrid and similarly equipped conventional vehicles, a variet ...

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. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak Open spreadsheet a. At the

level of significance, test for significant effects due to class, type, and interaction. \table[[\table[[Source],[of Variation]],\table[[Sum of Squares],[(to 2 decimals)]],\table[[Degrees],[of Freedom]],\table[[Mean Square],[(to 2 decimals)]],(to 2 decimals)],[Class,,,,],[Type,,,,],[Interaction,,,,],[Error,,,,],[Total,,,,]] b. The

-value for the class of vehicle is

What is your conclusion with respect to the class of vehicle? evidence to conclude that the fuel efficiency is not the same for the four classes of vehicle.