Question

The table below shows that costs per mile (in cents) for a sample of automobiles.

Small sedan	Medium sedan	Large sedan	SUV 4WD	Minivan
43	67	64	87	66
41	49	73	66	76
49	63	83	75	59
54	59	75	78	51
46	64	80		70
	52	72

Use the one-way ANOVA test in Excel to complete the following table (round decimals to three decimal places)

ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	Answer	Answer	Answer	Answer	Answer	Answer
Within Groups	Answer	Answer	Answer
Total	Answer	Answer

)Using α = 0.05, what do you conclude? (Reject the null hypothesis or Do not reject the null hypothesis

Answer 1

The output is:

ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	2950.946154	4	737.7365385	13.09702199	0.0000167	2.840099807
Within Groups	1182.9	21	56.32857143
Total	4133.846154	25

Using α = 0.05, Reject the null hypothesis.

Calculations:

Go to data-data analysis-One way anova

The inputs are:

The output: