The data shown in the following table are the deviations from nominal diameter for holes drilled in a carbon-fiber composite material used in aerospace manufacturing. The values reported are deviations from nominal in ten-thousandths of an inch. You will be creating an x-bar and s chart.

Calculate the x-double-bar and s-bar values and show the formulas (0.25 points).

Calculate the Upper Control Limit (UCL) and Lower Control Limit (LCL) for the x-bar chart. Please show the formulas (0.25 points).

Calculate the Upper Control Limit (UCL) and Lower Control Limit (LCL) for the s chart. Please show the formulas (0.25 points).

Now that you know the UCL and LCL for both x-bar and s charts, please create both charts with UCL and LCL in Excel. Does the process seem to be in statistical control? Why? Why not? (0.25 points)

Sample	x1	x2	x3	x4	x5
1	-30	50	-20	10	30
2	0	50	-60	-20	30
3	-50	10	20	30	20
4	-10	-10	30	-20	50
5	20	-40	50	20	10
6	0	0	40	-40	20
7	0	0	20	-20	-10
8	70	-30	30	-10	0
9	0	0	20	-20	10
10	10	20	30	10	50
11	40	0	20	0	20
12	30	20	30	10	40
13	30	-30	0	10	10
14	30	-10	50	-10	-30
15	10	-10	50	40	0
16	0	0	30	-10	0
17	20	20	30	30	-20
18	10	-20	50	30	10
19	50	-10	40	20	0
20	50	0	0	30	10