Question: Hello. I need help creating quality control charts for this data on excel. It shows 5 groups counting the colors of M&Ms in 5 packs,

Hello. I need help creating quality control charts for this data on excel. It shows 5 groups counting the colors of M&Ms in 5 packs, how do I create these charts? It doesn't work my UCL and LCLs don't work. Does it have to be for each group or all together?

Hello. I need help creating quality control charts for this data on

Group Pack Red Pink Orange Purple Brown Yellow Green Blue 34 40 48 25 28 30 17 24 2 30 51 27 19 29 34 24 32 3 29 43 36 28 21 36 19 28 43 34 33 23 18 24 36 36 5 41 26 31 15 21 37 28 45 32 40 48 31 28 31 16 18 N 30 51 27 46 29 36 24 5 W 28 43 36 43 21 36 19 14 43 34 33 27 18 25 36 31 2 5 41 26 31 19 21 37 28 42 32 38 48 24 28 30 16 23 29 51 27 18 28 36 24 34 WU 28 43 37 28 21 35 19 29 43 34 33 23 18 25 36 33 41 26 31 18 21 47 27 42 32 40 48 28 18 30 17 19 32 40 48 28 18 30 17 19 3 28 43 36 28 22 36 19 29 43 34 33 58 18 25 36 0 4 UT 41 26 31 18 21 37 29 42 32 40 48 38 28 30 16 11 30 51 27 48 29 26 24 5 W 28 43 26 43 21 36 19 14 4 43 34 33 52 18 25 36 6 5 5 42 26 30 60 21 37 27 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!