Question

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

Answer 1

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