Excel Project Report Introduction:
This project report is about the project we did on M&Ms. My hypothesis for this project is that bags of equal weight should have the same amount of candies in it. All the colors aren’t represented equally because there are 6 different colors so there must be more of that color in each bag. The color distribution doesn’t remain constant because the little bag will have less candies and the bigger bag will have more candies for each color.

Data Collection:
This project we are doing is on M&Ms. We opened the mini bags of M&Ms and recorded how many of each color there were and recorded it in the table under bag1. Then we went to 5 other peoples M&Ms and recorded how much M&Ms were there for each color and recorded those under bags 2, 3, 4, 5, and 6. Then I put that information in 3 different graphs. My Table of the Data:
Colors Blue Brown Green Orange Red Yellow Total Ba Ba Ba Ba Ba Ba Avera g 1 g 2 g 3 g 4 g 5 g 6 ge 5 0 5 3 0 3 1 6 4 6 4 6 0 0 2 0 3 2 4 5 2 4 2 0 2 4 3 6 2 3 2 0 4 1 5 4 2 1 1 7 4 1 9 3 0 0 1 7 4 2 5 5 1 2 18

Data Analysis:
My dat ta reveals that every color r doesn’t have the e same am mount for that co olor there e are all d different. . Only a fe ew bags have the same amoun nt of that t color as the othe er bag. ta shows s that the e average amount of yellow w M&Ms is about 2. My dat The av verage am mount for r Red is 1. The ave erage am mount for r orange is 4. The av verage am mount for r Green is s 5. The a average a amount fo or Brown n is 2. The average amount f for Blue i is 3. That all the min ni bags of f M&Ms t that have e equal w weight; weigh close mount of M&Ms in n each ba ag. From my resea arch I got t 16 to the same am Bag 1. I go ot 20 for bag 2. I g got 18 for r bag 3. I g got 21 ba ags 4. I go ot from B 17 bag gs 5. I got 16 bags 6. My Gra aphs:

Ave erage
Yellow Red Colors Orange Green Brown Blue 0 1 2 3 Av verage 4 5 6 Average

10 9 8 7 Colors in each bag 6

Color Distruption

Blue 5 4 3 2 1 0 Bag 1 Bag 2 Bag 3 Bag 4 Bag 5 Bag 6 Brown Green Orange Red Yellow

Number of Bags

Total
20 0 18 8 16 6 14 4 Total M&Ms 12 2 10 0 8 6 4 2 0 Bag 1 Bag 2 Bag 3 Bag 4 4 Bag 5 Bag 6 Bag 1 Bag 2 Bag 3 Bag 4 Bag 5 Bag 6

Number of Bags s

Concl lusion:
My hyp pothesis for this p project w was wrong g. I found d this out after I research data for the 6 M M&M bags. I adde ed all the e M&Ms i in each bag . I found out that all the ba ags have different t amount t of to get my total. s one of m my bags h have the same as the other but all t the other rs M&Ms are a few M&M Ms off. This pr roject we e did was fun and I found o out some new thin ngs. I found out tha at every m mini bag of M&M Ms have di ifferent a amounts but they are pretty close to another mini bag of M&M Ms. By: Colleen Ran nkin