PLEASE USE EXCEL AND SHOW STEP BY STEP

A production manager at a tyre manufacturing plant has inspected the number of defective tyres in twenty random samples with twenty observations each. Following are the number of defective tyres found in each sample:

Sample No.	Sample Size	No. of defective tyres	Sample No.	Sample Size	No. of defective tyres
1	20	3	11	20	3
2	20	2	12	20	2
3	20	1	13	20	2
4	20	2	14	20	1
5	20	1	15	20	1
6	20	3	16	20	2
7	20	3	17	20	4
8	20	2	18	20	3
9	20	1	19	20	1
10	20	2	20	20	1

1. Construct a three-sigma control chart with this information. Is the process in statistical control?
2. Suppose that instead of sample size of 20, the sample size is 100. Use the given data to set up an appropriate control chart for this process. Is the process in statistical control?
3. Compare your control limits in parts (6.1) and (6.2)