Question
I need help analyzing and computing the data found in the attached spreadsheet. As part of a study designed to compare hybrid and similarly equipped
I need help analyzing and computing the data found in the attached spreadsheet.
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.
G18 V X V fx A B C D E F G H I J K L Make/Model Class Type MPG Rearrange the data for the Anova: Two-Factor With Replication Analysis 2 Honda Civic Small Car Hybrid 36 3 Honda Civic Small Car Conventional 28 Hybrid Conventional 4 Toyota Prius Small Car Hybrid 43 Small Car 5 Toyota Corolla Small Car Conventional 31 6 Chevrolet Malibu Midsize Car Hybrid 26 Midsize Car 7 Chevrolet Malibu Midsize Car Conventional 22 8 Nissan Altima Midsize Car Hybrid 31 Small SUV 9 Nissan Altima Midsize Car Conventional 26 10 Ford Escape Small SUV Hybrid 28 Midsize SUV 11 Ford Escape Small SUV Conventional 22 12 Saturn Vue Small SUV Hybrid 28 13 Saturn Vue Small SUV Conventional 21 14 Lexus RX Midsize SUV Hybrid 24 After reading these instructions delete all text in this shaded area. 15 Lexus RX Midsize SUV Conventional 20 16 Toyota Highlander Midsize SUV Hybrid 25 Use the XLMiner Analysis ToolPak to conduct your Anova: Two-Factor With Replication analysis. 17 Toyota Highlander Midsize SUV Conventional 19 18 After deleting al text in this shaded area, set the output range in the ToolPak to the top left cell 19 of this area (F14). 20 21 Your Anova analysis output should fit into this shaded area. 22 23 24a. At the a = .05 level of signicance, test for signicant effects clue to class, type, and interaction. b. The p-value for the class of vehicle is Source Sum of Squares Degrees Mean Square F of Variation (to 2 decimals) of Freedom (to 2 decimals) (to 2 decimals) Class :1 |:] |:] :1 Type :1 |:] |:] :1 :1- What is your conclusion with respect to the class of vehicle? There is 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 C]. What is your conclusion with respect to the interaction between class and type of vehicle? The interaction between type and class of vehicle statistically signicantStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started