As a process owner, you have been tasked with developing a x-bar chart. Youve collected the following data.

Calculate the upper and lower control limits using a 3-sigma performance level and build your x-bar chart. Begin by calculating the overall standard deviation and standard error.

Sample Number	Values for Each Item in the Sample
1	59	45	51
2	45	57	41
3	42	43	45
4	57	57	50
5	53	55	40
6	52	48	50
7	50	51	45
8	49	47	56
9	56	50	41
10	60	40	50

Now, compute the upper and lower control limits using the range as your measure of variability.

Finally, having built a control chart, you started to collect data, sampling three items every 30 minutes. Your data for the first five samples are shown below. Plot them on your control chart. Is your process in control?

Sample Number	Values for Each Item in the Sample
1	57	47	51
2	45	59	45
3	44	49	55
4	55	59	55
5	57	49	53

*PLEASE USE EXCEL AND TAKE A SCREENSHOT OF THE EXCEL AND INCLUDE SCREENSHOTS IN THE ANSWER*

Calculate mean, grand mean, standard deviation, r bar, you can do it all there. you need to comment on what you interpret from the charts? is the process in control or not, somewhere in between?