Math help excel M&M Project.

profileteron50
mnmproject_10-29-12.xls
Home>Mathematics homework help>Math help excel M&M Project.

Data

Blue Orange Green Yellow Red Brown Num. of Candies in Bag bin
10 18 5 5 7 9 54 50
12 15 5 6 9 10 57 51
10 19 7 6 7 10 59 52
18 8 5 8 6 9 54 53
15 15 3 7 8 6 54 54
13 12 8 6 9 5 53 55
13 22 9 6 5 3 58 56
11 9 6 13 14 3 56 57
14 12 9 7 9 5 56 58
13 15 7 5 8 7 55 59
11 19 8 6 4 7 55 60
8 12 16 5 8 8 57
14 11 2 12 5 12 56
8 10 9 10 9 14 60
7 6 18 9 8 8 56
11 16 6 9 5 8 55
9 10 12 6 9 10 56
12 14 9 6 7 6 54
13 15 8 6 5 8 55
10 15 11 5 9 8 58
13 9 14 7 4 11 58
17 11 8 3 6 9 54
24 12 5 7 5 2 55
13 10 18 10 4 5 60
14 18 8 7 9 1 57
8 15 15 6 7 5 56
14 8 13 10 8 2 55
10 19 10 9 6 5 59
13 9 14 8 5 10 59
14 11 10 6 7 9 57
10 8 15 9 7 5 54
14 11 9 5 9 9 57
11 8 11 5 7 14 56
13 9 15 12 4 4 57
10 11 21 3 5 7 57
11 9 12 10 3 10 55
5 10 12 12 12 7 58
9 12 12 10 9 5 57
13 13 8 11 7 3 55
12 14 14 3 6 6 55
17 13 13 4 5 4 56
8 8 14 11 7 12 60
8 13 11 11 8 7 58
16 9 8 5 8 9 55
6 13 6 10 12 6 53
5 13 12 6 10 9 55
6 9 9 11 9 14 58
10 9 4 10 11 13 57
14 10 2 13 7 10 56
10 10 9 10 7 9 55
580 607 495 387 365 378 2812 <== TOTALS
SUMS Num Bags
1160 1214 990 774 730 756 5624 51

Part 2 Summary

Blue Orange Green Yellow Red Brown
x
p <--- carry at least 4-6 decimals for future calculations involving these statistics.
Sample mean number of candies per bag
<-- carry at least 4-6 decimals for future calculations involving these statistics.
Sample Standard deviation of mean number of candies per bag
<-- carry at least 4-6 decimals for future calculations involving these statistics.
Histogram <-- describe the histogram shape and identify any outliers
Sample size
Number of candies sampled
Number of bags sampled