用excel制作质量控制图

样本号x1x2x3x4x5Ri1473244352035.6272193731253429.2183191116114420.2334292942593839.4305281245362529.2336403511383331.4297153012332623.22183544321138323392737262035291710234526373232.62211284440311832.22612312524322226.81013223719471427.83314373212383029.82615254024501931.6311673123183222.2251738041403731.24118351229482028.83619312035244731.42720122738403129.62821524252242539282220311532819.42823294741322234.22524282722325432.63225423415292128.22729.86427.44控制图：CL=29.86429.86429.86429.86429.864ULC=45.69745.69745.69745.69745.697LCL=14.03114.03114.03114.03114.03135.629.220.239.429.231.423.232051015202530354045501 2 3 4 5 6 7 8 9（%）xRxR图CL=27.4427.4427.4427.4427.44UCL=58.03658.03658.03658.03658.0365.X-Rs控制图子样号XRs13.76-23.490.2733.750.2643.660.0953.620.0463.640.0273.590.0583.580.0193.670.09103.630.04113.670.04123.630.04133.660.03143.810.151 2 3 4 5 6 7 8 9271833303329210102030405060701 2 3 4 5 6 7 8R（%）图153.97 0.16163.64 0.33173.67 0.03183.60.07193.61 0.01203.610213.60.01223.68 0.08233.66 0.02243.62 0.04253.61 0.01平均数3.65720.07875X控制图：CL=3.657 3.6573.6573.6573.657UCL=3.8673.8673.8673.8673.867LCL=3.44703.4473.4473.4473.447R控制图CL=0.079 0.0790.0790.0790.079ULC=0.2580.2580.2580.2580.2583.13.23.33.43.53.63.73.83.944.11 2 3 4 5 6 7 8 9X图0.150.20.250.30.3500.050.1123456723.2322932.632.226.827.829.831.622.231.228.831.429.63919.434.232.628.29 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29样组号9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29样组号2921331722261033263125413627 28 28 282532277 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29样组号系列1CL=27.44U CL=58.036线性 (CL=27.44)线性 (U CL=58.036)8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29样组号系列1CL=3.657U CL=3.867LCL=3.447线性 (CL=3.657)线性 (CL=3.657)线性 (U CL=3.867)线性 (LCL=3.447)系列1CL=0.079U LC=0.258线性 (CL=0.079)789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29线性(CL=0.079)线性(U LC=0.258)