Question

Month	Chevy Cruze	Ford Focus	Hyundai Elantra	Honda Civic	Toyota Corolla	VW Jetta
January	21,711	21,303	21,006	19,341	20,985	19,671
February	18,274	19,385	19,992	20,872	19,785	19,105
March	17,934	16,557	15,713	17,181	16,889	16,006
April	19,387	17,420	15,054	14,500	14,093	14,083
May	17,097	16,147	15,023	15,800	15,727	16,875
June	16,244	16,173	14,295	15,058	15,236	16,893

a. run the data using ANOVA on Excel. You may choose which ANOVA is most appropriate.

b.   Show the Excel ANOVA output and describe what the output means.

Answer 1

Anova: Two-Factor Without Replication
SUMMARY	Count	Sum	Average	Variance
January	6	124017	20669.5	892146.3
February	6	117413	19568.83	769914.2
March	6	100280	16713.33	653005.1
April	6	94537	15756.17	4717579
May	6	96669	16111.5	597021.5
June	6	93899	15649.83	905859.8
Chevy Cruze	6	110647	18441.17	3701180
Ford Focus	6	106985	17830.83	4369303
Hyundai Elantra	6	101083	16847.17	8305758
Honda Civic	6	102752	17125.33	6374508
Toyota Corolla	6	102715	17119.17	7349288
VW Jetta	6	102633	17105.5	4204497
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
month	1.4E+08	5	27947623	21.98208	2.04E-08	2.602987
Columns	10893073	5	2178615	1.71358	0.168264	2.602987
Error	31784556	25	1271382
Total	1.82E+08	35

p value for month = 0.0000 , so significant

there is an effect of month

.............

p value for column for 0.168

p value > 0.05

so not significant

.........................

THANKS

revert back for doubt

please upvote