QUESTION 22 (10 points) - Xbar-Charts & R-Charts

Based on a data sample in file "TOM3010_OM_HW3_Question22_Data.xlsx", you need to construct one Xbar-chart and one R-chart with the following guidelines:

• Background, equations, lookups and Excel examples (with videos) are in Module 05.
• Charts must have titles, labels, and clear presentation of different lines.

(a)[5] You need to have one Xbar-chart. The Xbar-chart should have the vertical axis format as: Min = 35; Max = 70; and Major Unit = 5. The horizontal axis has 60 points. Besides the chart, present the following mini table (points will be deducted if you show the big table of full data). Give interpretations of the chart results: the process is in control or out of control, and why.

Table 22.1 (first 2 Excel columns)
x-2bar	(value & unit)
SD(all parts)	(value & unit)
SE(Xbar)	(value & unit)
UCL-Xbar	(equation, value & unit)
LCL-Xbar	(equation, value & unit)

(b)[5] You need to have one R-chart. The R-chart should have the vertical axis format as: Min = 0; Max = 80; and Major Unit = 10. The horizontal axis has 60 points. Besides the chart, present the following mini table (points will be deducted if you show the big table of full data). Give interpretations of the chart results: the process is in control or out of control, and why.

Table 22.2 (first 2 Excel columns)
R-bar	(value & unit)
D4	(value)
D3	(value)
UCL-R	(equation, value & unit)
LCL-R	(equation, value & unit)

Question 22: Sample Data for both R-Chart and Xbar-Chart
Sample size (n)	12
#Samples (k)	60
Data for 60 samples (12 items in each sample) in pounds per item (weight)
Sample	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	51	52	53	54	55	56	57	58	59	60
Item 1	38.612	57.933	42.010	40.634	55.625	60.897	57.429	55.015	45.660	51.807	22.892	69.654	26.224	72.979	28.184	36.927	32.960	53.611	51.448	36.069	34.782	48.788	51.416	33.846	57.748	46.134	47.472	48.357	59.800	46.647	29.120	35.242	30.030	47.790	54.974	42.625	53.457	19.733	50.877	50.147	35.651	46.982	52.842	35.577	54.216	56.215	59.393	47.160	54.134	50.306	46.371	38.726	55.175	64.718	65.779	75.398	61.560	60.400	63.906	55.544
Item 2	54.906	59.584	43.611	56.543	36.565	54.925	50.925	47.852	56.056	62.165	35.839	48.004	84.924	58.080	41.354	65.034	36.321	62.006	59.793	23.513	62.265	44.015	57.688	59.046	59.042	69.638	46.668	48.646	49.105	59.199	69.295	32.417	52.177	37.626	58.048	57.292	53.665	51.729	37.806	35.721	51.631	46.556	43.439	55.708	47.422	56.539	69.979	58.429	58.979	51.826	55.179	35.992	56.675	53.225	56.245	57.716	69.973	48.503	73.750	81.461
Item 3	56.664	61.132	55.098	46.677	35.796	59.424	54.181	43.438	45.503	45.137	40.335	42.498	60.010	36.236	28.915	68.193	56.478	63.598	62.607	43.068	48.851	60.005	53.527	53.288	40.451	58.271	54.424	46.653	42.080	37.780	75.346	39.922	46.952	44.680	44.858	87.670	41.733	38.139	42.279	54.255	64.435	43.748	58.989	51.429	46.313	50.218	38.886	37.485	44.679	43.533	70.276	57.011	72.476	41.648	42.189	74.716	60.642	59.083	55.969	60.127
Item 4	36.262	57.642	57.751	43.800	60.272	55.882	53.109	47.310	41.424	49.912	48.479	49.264	50.522	58.457	32.116	64.882	45.420	50.409	9.494	50.583	44.843	48.069	62.408	48.191	46.095	50.667	65.429	43.334	56.987	56.296	34.651	48.117	43.187	89.055	27.749	37.139	45.236	47.750	40.355	13.313	49.890	47.195	50.516	48.312	37.423	46.704	61.764	42.864	58.232	50.955	59.209	50.622	76.138	58.201	64.668	43.595	58.057	67.720	88.759	69.947
Item 5	51.312	27.928	41.168	55.404	46.451	48.862	53.656	47.291	44.938	55.425	60.291	28.970	53.205	25.012	53.084	44.733	63.420	18.854	48.891	40.396	62.525	46.140	59.242	28.962	40.290	33.751	63.857	51.380	55.089	62.190	65.413	55.487	64.941	62.467	67.980	53.668	45.715	65.167	39.096	52.156	62.565	41.269	46.902	32.026	50.886	52.856	33.755	41.831	51.641	46.918	52.829	61.091	69.859	65.142	52.822	66.614	72.885	64.375	55.019	48.210
Item 6	29.151	58.782	52.449	45.100	45.787	51.367	46.184	35.860	51.429	51.425	45.163	37.195	58.316	50.171	35.815	55.752	66.926	60.710	35.997	63.121	52.210	40.892	48.756	66.043	44.073	50.210	40.568	55.420	50.810	48.879	39.718	64.665	75.346	32.318	48.759	48.926	60.386	57.497	44.685	26.736	56.957	59.581	51.617	47.783	55.138	48.542	48.531	62.206	45.564	59.231	55.103	74.232	70.311	55.353	46.169	78.142	51.378	53.001	55.236	64.345
Item 7	43.513	52.039	46.961	45.360	51.028	44.582	39.378	58.815	56.835	44.156	63.380	19.359	24.550	86.790	32.668	42.879	68.410	41.713	28.900	34.721	48.773	44.997	37.456	44.395	47.290	47.710	47.286	40.538	58.712	61.815	41.068	39.107	42.201	50.100	55.378	29.319	63.283	73.289	63.097	30.457	57.170	50.039	52.773	34.345	58.689	54.394	49.767	50.385	57.010	57.001	65.161	58.299	43.491	56.358	61.747	50.852	49.405	67.121	50.572	53.841
Item 8	53.386	46.932	48.771	63.541	59.711	53.812	60.726	54.213	49.568	50.069	27.745	75.943	79.993	40.347	27.619	50.757	26.374	81.720	54.774	96.092	49.158	45.605	43.146	56.794	61.601	50.362	64.633	39.856	45.842	44.103	66.103	63.162	45.735	20.695	68.871	41.819	68.029	78.450	72.969	10.313	52.881	57.525	43.677	55.528	59.879	39.308	50.434	38.998	50.121	47.533	49.301	46.456	73.043	76.518	59.176	39.652	55.569	50.096	73.193	73.835
Item 9	48.587	61.210	46.377	62.508	54.759	51.887	50.084	43.142	48.148	54.858	41.231	52.452	47.041	74.451	36.821	32.895	35.862	59.292	69.623	40.740	46.187	51.636	45.642	61.359	48.030	47.260	44.184	62.571	52.714	47.228	41.579	79.880	42.482	57.499	45.653	40.448	66.235	33.802	56.425	68.920	48.862	48.278	58.738	47.193	36.315	57.319	48.935	64.243	61.800	59.131	66.107	60.268	67.090	79.301	65.559	46.205	61.904	64.197	41.602	61.856
Item 10	62.155	43.031	41.765	49.856	39.287	39.106	45.236	36.052	53.072	60.854	42.431	42.104	42.359	80.208	55.233	45.905	51.828	33.857	45.543	43.123	50.046	46.991	54.592	44.446	43.407	32.558	37.033	47.946	60.161	50.695	48.032	38.084	40.036	24.908	46.378	42.823	58.323	54.266	34.607	28.530	58.235	67.115	49.320	52.821	60.846	45.382	48.131	47.679	54.441	49.621	70.700	51.739	55.189	67.965	64.855	56.414	67.650	43.644	63.086	55.637
Item 11	63.432	50.873	50.555	41.214	53.228	49.406	42.095	48.256	32.444	52.902	51.350	48.015	65.152	61.940	64.814	35.635	52.980	47.427	70.120	48.762	49.576	57.071	52.714	44.934	61.979	43.580	39.956	65.152	35.614	48.716	54.783	40.740	57.013	50.184	28.237	42.520	47.955	61.777	54.427	47.002	58.875	46.404	49.574	56.248	32.183	40.845	42.779	59.858	48.407	50.003	64.414	61.212	69.027	43.006	61.194	48.169	66.647	62.514	43.019	61.292
Item 12	49.483	46.405	54.954	39.206	48.354	47.442	55.078	44.675	50.128	31.862	31.053	69.184	49.159	46.367	62.699	59.011	53.003	32.707	40.198	27.642	42.857	47.405	41.523	48.208	52.559	41.938	59.954	52.850	43.124	53.474	39.674	51.195	21.309	34.452	50.855	56.258	69.128	34.109	45.116	35.476	59.033	51.868	49.205	53.252	49.096	31.941	52.979	59.542	39.938	39.148	58.712	50.238	55.182	73.240	64.911	47.448	67.633	72.362	77.239	62.903