USE EXCEL AND SHOW STEPS BY STEP PLEASE

In a manufacturing industry the plate thickness is one of the important CTQ factor, during Measure phase, project team performed the process capability study and identified that the process is not capable (less than 2 sigma). In Analyse phase collected 20 sets of plate thickness samples with a subgroup size of 4.

Sample	Measured Valued
	1	2	3	4
1	44	26	24	34
2	50	48	51	43
3	32	28	26	22
4	52	55	56	44
5	16	16	21	26
6	36	36	35	31
7	21	22	18	21
8	29	21	23	22
9	26	46	44	14
10	24	22	22	44
11	18	24	24	49
12	24	20	26	23
13	19	21	27	28
14	8	11	12	12
15	24	18	27	24
16	56	52	56	50
17	32	22	18	25
18	8	12	11	17
19	51	54	52	49
20	30	28	35	22

1. What type of Control Charts would you use with these data? Why?
2. What is the process mean?
3. What is the process standard deviation (use both methods)?
4. Compute the values for the upper and lower control limits for both the upper and lower plotting areas.
5. Plot the Control Chart.
6. Are there any signals of special cause variation? If so, what rule did you apply to identify the signal?