The data shown in the following table are x-bar and R values for 24 samples of size n = 5 taken from a process producing bearings. The measurements are made on the inside diameter of the bearing, with only the last three decimals recorded (i.e., 34.5 should be 0.50345). You will be creating an x-bar and R chart.

Calculate the x-double-bar and R-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. Hint: factors for calculating UCL and LCL can be found in the Appendix of the textbook (0.25 points).

Calculate the Upper Control Limit (UCL) and Lower Control Limit (LCL) for the R chart. Please show the formulas. Hint: factors for calculating UCL and LCL can be found in the Appendix of the textbook (0.25 points).

Now that you know the UCL and LCL for both x-bar and R 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	(x-bar)	R
1	34.5	3
2	34.2	4
3	31.6	4
4	31.5	4
5	35.0	5
6	34.1	6
7	32.6	4
8	33.8	3
9	34.8	7
10	33.6	8
11	31.9	3
12	38.6	9
13	35.4	8
14	34.0	6
15	37.1	5
16	34.9	7
17	33.5	4
18	31.7	3
19	34.0	8
20	35.1	4
21	33.7	2
22	32.8	1
23	33.5	3
24	34.2	2