Thirty samples of size 3, available in the worksheet C16P4 in the OM6 Data Workbook were taken from a machining process over a 15-hour period. Construct control charts using the Excel template xBar&R-chart. Verify the Excel calculations of the control limits by hand using the formulas in the chapter. Does the process appear to be in statistical control? Why or why not?

DATA	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50
1	31	26	25	17	38	41	21	32	41	29	26	23	17	37	18	30	28	40	18	22	36	29	40	34	31	41	36	35	38	42
2	42	18	30	25	29	42	17	26	34	17	31	19	24	35	25	42	36	29	29	34	22	37	35	44	37	45	41	49	45	44
3	28	35	34	21	35	36	29	28	33	30	40	25	32	17	29	31	32	31	28	26	26	31	46	42	39	34	34	40	40	32
4
5
6
7
8
9
10

Average	33.67	26.33	29.67	21	34	39.67	22.33	28.67	36	25.33	32.33	22.33	24.33	29.67	24	34.33	32	33.33	25	27.33	28	32.33	40.33	40	35.67	40	37	41.33	41	39.33	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
LCLx-bar	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83	20.83
Center	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88	31.88
UCLx-bar	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93	42.93

Range	14	17	9	8	9	6	12	6	8	13	14	6	15	20	11	12	8	11	11	12	14	8	11	10	8	11	7	14	7	12	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
LCLrange	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Center	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8	10.8
UCLrange	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8	27.8