supply chain aassighnmnet

profileAngela gomez
excel1.xlsx

Data & Charts

M&M Checksheet
Team # A
Bag Identifier # of Red # of Yellow # of Blue # of Orange # of Green # of Brown
NAS-567 3 4 6 6 5 3
Candy Piece # Lengths in (mm)
1 12.00
2 11.38
3 11.84
4 13.20 Insert Bar Chart - M&M Colors Insert Histogram - M&M Lengths
5 11.84 **** Here***** **** Here*****
6 11.69
7 10.75
8 10.28
9 10.60
10 11.06
11 12.15
12 13.09
13 12.00
14 12.78
15 11.53
16 11.22
17 12.16
18 13.25
19 12.78
20 11.69
21 10.92
22 13.40
Insert Pareto - M&M Colors
**** Here*****

Conclusions

Activity #
4 What are the percentages of each color in your sample (fill in the percentage in each box next to the appropriate candy color)?
Candy Color Number of Pieces Percentage of Total Lower Control Limit Upper Control Limit
Red 3 10.80% 13.20%
Yellow 4 13.50% 16.50%
Blue 6 20.70% 25.30%
Orange 6 20.70% 25.30%
Green 5 13.50% 16.50%
Brown 3 10.80% 13.20%
5 Conclude whether or not the percentages of your sample are reasonably within the expectations communicated by Mars Inc. (within the provided control limits)