Math 175 Intro Statistics Project 4 A company claims there is no difference between their prices (in dollars) charged on items produced at production levels A, B, C, and D. Construct the appropriate...

It is an excel project


Math 175 Intro Statistics Project 4 A company claims there is no difference between their prices (in dollars) charged on items produced at production levels A, B, C, and D. Construct the appropriate null and alternative hypotheses by hand. Use Excel to enter “price A” in cell a1, “price B” in cell b1, “price C” in cell c1, and “price D” in cell d2. Starting with cell a2, enter A prices. Starting with cell b2, enter B prices. Starting with cell c2, enter C prices. Starting with cell d2, enter D prices. Use data >> data analysis >> ANOVA single factor. Place this information in cell g2. Be sure to enter a2:d12 (far enough to encompass all data) List the test statistic TS= F =______________. List the critical value CV=______________. Determine whether to support or reject the claim at the significance level. A pricesB pricesC pricesD prices 17181913 16192013 12131414 15131617 19171219 191820 1619 15 20 11 19 0.05 a =