Proportion of each color of M&M

Jan 23rd, 2015
Business Finance
Price: $10 USD

Question description

Let's calculate the proportion of each color of M&M from our bag and compare it to what the website says we should have gotten. We see that our total sample size is now, = 200. 

There are 27 Brown M&M's, 35 yellow M&M's, 28 Red M&M's, 46 Blue M&M's, 30 Orange M&Ms and 34 Green M&M's in our bag of M&M's.


  1. In a Word document, answer the following questions:
  • Which colors are higher, lower, or the same proportion as the website?
  • How close are our numbers to what the company says we are supposed to get?
  • Is any color an outlier?
  • Do you think the Mars Company favors one color over another? Why or why not?
  • When comparing our proportions to the website's proportions do you think our calculations are an over prediction, under prediction or the same prediction as what to expect from a bag of M&Ms. Why?
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?
  • Which color has the highest proportion and which color has the lowest proportion and what are they?
Submit both the Excel spreadsheet and the Word document.

Tutor Answer

(Top Tutor) Caramarie M
School: UCLA

Studypool has helped 1,244,100 students

Review from student
" Outstanding Job!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1824 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors