In: Statistics and Probability
a. Re-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.
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 |
Run Anova single factor analysis in excel followed by below procedures:
Result:
P-value is 0.85 , which is greater than the significance level 0.05
If the p-value is greater than the significance level, you do not have enough evidence to reject the null hypothesis that the population means are all equal.