Assignment Part #$1$

After completing the videos and readings included in the Six Sigma Quality module, you should have a basic understanding of how to use the seven tools of quality. This exercise will allow you to apply what you have learned to an M&M quality study.

This assignment includes an Excel spreadsheet that contains one check sheet from an M&M process control study $($one team member$$s check sheet$).$ Open the Excel file and familiarize yourself with the data. The research involves counting the number of each M&M individual candy piece$$s color and measuring the length of each M&M in a single serving bag. We want to understand the distribution of colors of M&M candy pieces and analyze the production process concerning the size of each M&M$.$

Your job is to complete the following:

Analysis $$ Complete Activities $1$ through $4$ on the Excel Tab titled $$Colors & Lengths$$:

$$ Activity #$1($use the Excel Tab titled $$Colors & Lengths$)$: Using data from the M&M color recording section of the check sheet, create a bar chart using Excel that details each color$$s number represented in the bag. The bar chart format should replicate the following $($title$,$ axis titles, categories, etc.$)$