Hw

profilesmai20

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:

 

  1. 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?
  2. 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.
  3. 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.
  4. 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?
  5. Submit both the Excel spreadsheet and the Word document.
    • 8 years ago
    • 5
    Answer(2)

    Purchase the answer to view it

    blurred-text
    • attachment
      word_doc..docx
    • attachment
      histogram_excel.xlsx
    • attachment
      pie_chart.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      mms.docx
    • attachment
      mms.xlsx
    Bids(1)
    other Questions(10)