Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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.

image text in transcribedimage text in transcribed
A B C D Make/Model Class Type MPG 2 Honda Civic Small Car Hybrid 36 3 Honda Civic Small Car Conventional 27 4 Toyota Prius Small Car Hybrid 45 5 Toyota Corolla Small Car Conventional 33 6 Chevrolet Malibu Midsize Car Hybrid 27 7 Chevrolet Malibu Midsize Car Conventional 22 8 Nissan Altima Midsize Car Hybrid 32 9 Nissan Altima Midsize Car Conventional 26 10 Ford Escape Small SUV Hybrid 26 11 Ford Escape Small SUV Conventional 22 12 Saturn Vue Small SUV Hybrid 28 13 Saturn Vue Small SUV Conventional 22 14 Lexus RX Midsize SUV Hybrid 24 15 Lexus RX Midsize SUV Conventional 18 16 Toyota Highlander Midsize SUV Hybrid 25 17 Toyota Highlander Midsize SUV Conventional 19a. 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting

Authors: Charles T. Horngren, Walter T. Harrison Jr., M. Suzanne Oliv

9th Edition

130898414, 9780132997379, 978-0130898418, 132997371, 978-0132569309

Students also viewed these Mathematics questions

Question

Distinguish among first-, second-, and third-degree bums.

Answered: 1 week ago