Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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?
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 0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started