All information is provided below. The complete questions and the excel data in order to solve each question. Thank you in advance!

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. X Open spreadsheet a. At the a =.06 level of significance, test for significant effects due to class, type, and interaction. Mean Source Sum of Degrees Square F of Squares of (to 2 (to 2 Variation (to 2 decimals) Freedom decimals) 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 sufficient 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 sufficient * @ 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 is not # statistically significant.A B C D Make/Model Class Type MPG Honda Civic Small Car Hybrid 38 Honda Civic Small Car Conventional 28 Toyota Prius Small Car Hybrid 45 Toyota Corolla Small Car Conventional 31 Chevrolet Malibu Midsize Car Hybrid 27 Chevrolet Malibu Midsize Car Conventional 23 Nissan Altima Midsize Car Hybrid 31 Nissan Altima Midsize Car Conventional 24 Ford Escape Small SUV Hybrid 27 Ford Escape Small SUV Conventional 22 Saturn Vue Small SUV Hybrid 27 Saturn Vue Small SUV Conventional 23 Lexus RX Midsize SUV Hybrid 22 Lexus RX Midsize SUV Conventional 20 Toyota Highlander Midsize SUV Hybrid 25 Toyota Highlander Midsize SUV Conventional 19