Proportion of each color of M&M

Jan 23rd, 2015
HelloWorld
Category:
Accounting
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.

Requirements:

  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) Daniel C.
(997)
School: University of Virginia
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
Five Star Tutor
Dec 3rd, 2016
" Outstanding Job!!!! "
kpcutie
Nov 19th, 2016
" Excellent job "
Joemoe
Nov 10th, 2016
" <3 it, thanks for saving me time. "
Hemapathy
Nov 6th, 2016
" all I can say is wow very fast work, great work thanks "
pmallory
Oct 28th, 2016
" Totally impressed with results!! :-) "
kevin12622
Oct 14th, 2016
" Goes above and beyond expectations ! "
kiln82
Oct 5th, 2016
" awesome work thanks "
likeplum4
Sep 22nd, 2016
" Excellent work as usual "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1826 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