Question

# As part of a study designed to compare hybrid and similarly equipped conventional vehicles, a variety...

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.

a. At the a=0.05 level of significance, test for significant effects due to class, type, and interaction.

 Source of Variation Sum of Squares (to 2 decimals) Degrees of Freedom Mean Square (to 2 decimals) (to 2 decimals) Class Type Interaction Error Total

b. The p-value for the class of vehicle is .

(___)

c. The p-value for the type of vehicle is .

(___)

d. The p-value for the interaction between class and type of vehicle is .

(___)

` `
 Make/Model Class Type MPG Honda Civic Small Car Hybrid 37 Honda Civic Small Car Conventional 27 Toyota Prius Small Car Hybrid 43 Toyota Corolla Small Car Conventional 31 Chevrolet Malibu Midsize Car Hybrid 27 Chevrolet Malibu Midsize Car Conventional 23 Nissan Altima Midsize Car Hybrid 32 Nissan Altima Midsize Car Conventional 25 Ford Escape Small SUV Hybrid 26 Ford Escape Small SUV Conventional 21 Saturn Vue Small SUV Hybrid 28 Saturn Vue Small SUV Conventional 23 Lexus RX Midsize SUV Hybrid 22 Lexus RX Midsize SUV Conventional 19 Toyota Highlander Midsize SUV Hybrid 23 Toyota Highlander Midsize SUV Conventional 17

put above data in below format in excel:

 Hybrid Conventional Small Car 37 27 Small Car 43 31 Midsize Car 27 23 Midsize Car 32 25 Small SUV 26 21 Small SUV 28 23 Midsize SUV 22 19 Midsize SUV 23 17

from excel :data-data analysis: ANOVA: 2 factor with replication:

below is output:

 Source of Variation SS df MS F P-value class 428.5 3 142.83 24.31 0.0002 type 169 1 169.00 28.77 0.0007 Interaction 27.5 3 9.17 1.56 0.2730 Within 47 8 5.88 Total 672 15

b)\

p value for class =0.0002

c)

p value for type =0.0007

d)

p value for interaction =0.2730

#### Earn Coins

Coins can be redeemed for fabulous gifts.