Use Excel Data Analysis one-way Anova to test equal popularity of colors for the

Question

Use Excel Data Analysis one-way Anova to test equal popularity of colors for the data. Your conclusion is:

4

A) The pvalue of 0.36 is insignificant, reject Ho, the colors are unequally popular.

B) The pvalue of 0.36 is significant, reject Ho, the colors are equally popular.

C) The pvalue of 0.36 is insignificant, do not reject Ho, the colors are unequally popular.

D) The pvalue of 0.36 is significant, do not reject Ho, the colors are unequally popular

E) The pvalue of 0.36 is significant, reject Ho, the colors are unequally popular.

F) The pvalue of 0.36 is insignificant, reject Ho, the colors are equally popular.

G) None of the above are correct

H) The pvalue of 0.36 is significant, do not reject Ho, the colors are equally popular.

I) The pvalue of 0.36 is insignificant, do not reject Ho, the colors are equally popular.

Blue Green Yellow Orange 2 6 11 5 4 7 10 15 11 6 2 19 4 12 6 9 6 14 25 2 6 6 1 1 4 7 7 18 3 8 1 11 15 19 15 6 2 7 13 1 4 7 4 6 4 1 11 7 8 7 1 4 13 21 2 2 1 5 2 1 2 3 6 12 9 25 1 10 5 7 4 5 13

4

Explanation / Answer

for running one way ANOVA on above:

I) The pvalue of 0.36 is insignificant, do not reject Ho, the colors are equally popular.

Groups Count Sum Average Variance Blue 18 108 6 16.82353 Green 20 183 9.15 39.71316 Yellow 20 134 6.7 37.16842 Orange 16 119 7.4375 36.2625 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 106.1774 3 35.39245 1.081541 0.362655 2.735541 Within Groups 2290.688 70 32.72411 Total 2396.865 73

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.