PART 2: How many of each color are there in the mystery bag of M & M's? What's the percent distribution of the colors?
 BEFORE
opening you bag of "M&M's"®, predict the total (how many) and the
distribution of colors (how many of each are color) are in the bag. Use
the table below to enter your information:
Colors 
Predictions 
Actual Amounts 
Fraction 
Percent 
Blue 




Brown 




Green 




Orange 




Red 




Yellow 




Totals: 




 Calculate
the fraction for each of the colors. For example, if there were 6 red
M&M's in a bag of 30, then the fraction would be 6/30
 Now,
use the Percent Equation to calculate the percent for each of the
colors of M&M's. Fill in the Percent column with this information.
 Do your percentages equal 100%? Why is this important?
 In the table below, enter the class totals and calculate the Class percents
Colors 
Class Amounts 
Blue 

Brown 

Green 

Orange 

Red 

Yellow 

Class Total: 

PART 3: Using a Spreadsheet to calculate Percent
 Open candycircles.xls in a spreadsheet application (such as Excel).
 Enter the Class Amounts
the class calculated in Column B. For example, click the mouse in Cell
B2 and enter the class total amount of Blue M&M's. Continue for the
other colors.
 Now, click your mouse in Cell C2 and enter =B2/B8 as in the image to the right. This will calculate the class percent of Blue M&M's.
 Continue with the other cells. For example, enter =B3/B8 in Cell C3, =B4/B8 in Cell C4, etc.
 What's happening? Why?
 What is B8?
 Why did we make B8 the denominator in all the class percents?
PART 4: Use a Spreadsheet to create a Circle Graph
Circle graphs represent the entire amount, or 100% of a certain data,
which is then split into parts proportional in size to the amount that
each part represents.
 Use your mouse to Highlight all the information from Cells A1 to Cell B7.Do
this by clicking on cell A1 and dragging down and across to cell B7.
 Once the data is highlighted, find the Chart Wizard button and click it.
 Select Pie from the list of Chart Types and click Finish
 Click Next on the next screen

Slowly click twice on each of the circle slices (pieces) until the
individual piece is selected as in the image to the right. Notice the
small black squares around the individual piece.
 Once this piece is selected, rightclick on top of the piece and select Format Data Point from the menu options as in the image to the right.
 Select the color that matches the M&M according to the key and click OK. For example, select the Red color if the piece of the circle graph represents the Red M&M's.
 Repeat for each of the sectors
 Once
you've completed, click the Your Bag tab in the bottom of the screen
(see below) and calculate the Percents AND make a Circle Graphs using
only the information from your bag of M&M's.
