Question

2. A Rochester, NY firm produces grommets that have to fit into a slot in an assembly. Following are dimensions of grommets (in millimeters): a. Use x-bar and R charts to determine if the process is in control. I need to see how to do this all on excel

Sample	x
1	46	33	54	46	64
2	52	45	54	75	64
3	34	64	36	46	63
4	34	45	47	37	62
5	46	64	75	55	16

a. Use x-bar and R charts to determine if the process is in control.

I need to see how to do this all on excel i need to be able to set it all up. it has to be turned in as a excel spreadsheet.

Answer 1

R 2 A B C D E F G H I J K L M N O P Q 1 Compute X and R for each sample Plot control charts using Xbar, R and control limits 2 X is computed as average of the observations for each sample. 3 Ris computed by subtracting the minimum value from the maximum value of each sample Observations Sample # 1 Ž R CLx LCL UCL CLR LCL UCLR R-chart X-chart 48.601 31 50.28 29.74 70.82 35.60 0.00 75.26 TRUE TRUE | 75 64 | 58.00 30 || 50.28 29.7470.82 35.60 0.00 75.26 TRUE TRUE 48.601 30 50.28 | 29.74 | 70.82 35.60 0.00 75.26 TRUE TRUE 45.00 28 50.28 29.74 70.82 35.60 0.00 75.26 TRUE TRUE 5 46 51.20 59 50.28 29.74 70.82 35.60 0.00 75.26 TRUE TRUE Average = 50.280 35.600 75 16 Compute X and Ā R-Chart 8.-_ * * T *= 50.280 kk _ R_R. +R, + .... R kk D- R = 35.600 20 Control chart constants corresponding to sample size N Sample size, N = D3 = = = 5 0 2.114 0.577 2 Control limits for X-chart Control limits for R-chart X-Chart 80.00 70.00 UCLX = + A R = 70.821 UCLr DR = 75.258 30 LCLx = 7 - A R = 29.739 LCLr=DR = 0.000 50.00 31 In Control 32 Process control 33 0 X-value lie outside of control limits. 34 Therefore based on X-chart, the process is 35 36 O R-value lie outside of control limits. 37 Therefore based on R-chart, the process is In Control