75 M&Ms have been eaten, which would bring our new proportions for each color to:
12% Brown
16% Yellow
16% Red
12% Blue
24% Orange
20% Green
Requirements:
- In a Word document, answer the following questions:
- How Many M&Ms of each color were eaten?
- Based on our results which color is the favorite and which color is the least favorite?
- How do you know?
- Which colors are higher, lower, or the same proportion as the website?
- Using Excel, construct a Histogram with the frequency numbers of each color.
- Make sure there are appropriate labels on your histogram.
- Paste the histogram into your Word document.
- Using Excel, construct a pie chart using the proportions from each color.
- Make sure there are appropriate labels on your pie chart.
- Paste the pie chart into your Word document.
- Answer the following questions about the charts you’ve constructed.
- What do you see? What is the shape and distribution?
- Compare these charts and graphs to the charts and graph you created in the previous project assignment. What is the same and what is different between the two charts?
- Submit both the Excel spreadsheet and the Word document.