Transcript M&M Charting in Excel PowerPoint

M&M Charting
in
Excel
Row mate
3
total
brown
Row mate
2
blue
green
Row mate
1
yellow
orange
red
Mine
0
5
10
15
20
1) Predict the number of M&M’s by color from your bag, without opening
2) Record your prediction
3) Open your bag, count by color and record the actual numbers
Colors:
Red
Orange
Yellow
Green
Blue
Dark Brown
Total
Prediction
Actual
8
7
9
10
10
8
52
9
6
9
9
11
10
54
3) Share your actual data with the people in your row
Color
Billy
Mine
Mary
Alex
red
2
2
3
3
orange
2
3
3
2
yellow
2
3
2
2
green
2
2
2
3
blue
2
2
3
2
brown
2
3
3
3
total
12
15
16
15
4) Open a new Excel spreadsheet and format it as follows:
Color
Mine
**Mary
Row mate 2
Row mate 3
red
orange
yellow
green
blue
brown
total
5) Make sure you use your row-mates actual names**
Mean
Median
Questions?
• Think about what I have asked you to do.
•Who can tell me what the steps are for
collecting data today?
Color
red
orange
yellow
green
blue
brown
total
Mine
**Mary
Row mate 2
Row mate 3
Mean
Median
• Enter your data into your spreadsheet
• Using the Insert Formula function, find the
mean and median for your data
• Using Chart Wizard, graph your data
• Re-color your lines to match the M&M
color you are graphing
• Using Page Set-Up, add gridlines and turn
your page to landscape
• Add a custom header
• Hit print preview and raise your hand