Math help excel M&M Project.
Part 4 (21 pts)
Use the M&Ms® data to complete this assignment. You will be using the methods of 7.4 for the color proportions and 7.2 for the mean number of candies per bag. For the Bonus you will be using the methods of 7.5.
You can use StatCrunch to assist with the calculations. A link for StatCrunch can be found under Tools for Success in Course Home. Here is also a link: http://statcrunch.pearsoncmg.com/statcrunch/larson_les4e/dataset/index.html. You can also find additional help on both confidence intervals and StatCrunch in the Online Math Workshop under Tab: “MAT300 Archived Workshops”. Specifically you will be looking for Hypothesis Tests and Using Technology – Hypothesis Testing.
Submit your answers in Excel, Word or pdf format. Submit your file through the M&M® project link in the weekly course content. Be sure to state clear hypotheses, test statistic values, critical value or p-value, decision (reject/fail to reject), and conclusion in English (what does reject/fail to reject the null mean in terms of your hypotheses). When doing calculations for the color proportions, keep at least 4-6 decimal places sample proportions, otherwise you will encounter large rounding errors.
Masterfoods USA states that their color blends were selected by conducting consumer preference tests, which indicated the assortment of colors that pleased the greatest number of people and created the most attractive overall effect. On average, they claim the following percentages of colors for M&Ms® milk chocolate candies: 24% blue, 20% orange, 16% green, 14% yellow, 13% red and 13% brown.
3 pts. Test their claim that the true proportion of blue M&Ms® candies is 0.24 at the 0.05 significance level.
3 pts. Test their claim that the true proportion of orange M&Ms® candies is 0.20 at the 0.05 significance level.
3 pts. Test their claim that the true proportion of green M&Ms® candies is 0.16 at the 0.05 significance level….