当前位置:文档之家› 用excel制作质量控制图

用excel制作质量控制图

用excel制作质量控制图
用excel制作质量控制图

样本号x1x2x3x4x5 Ri 1473244352035.627

2193731253429.218

3191116114420.233

4292942593839.430

5281245362529.233

6403511383331.429

7153012332623.221

835443211383233

927372620352917

10234526373232.622

11284440311832.226

12312524322226.810

13223719471427.833

14373212383029.826

15254024501931.631

1673123183222.225

1738041403731.241

18351229482028.836

19312035244731.427

20122738403129.628

2152425224253928

2220311532819.428

23294741322234.225

24282722325432.632

25423415292128.227

29.86427.44 控制图:

CL=29.86429.86429.86429.86429.864 ULC=45.69745.69745.69745.69745.697 LCL=14.03114.03114.03114.03114.031

x R

R图

CL=27.4427.4427.4427.4427.44 UCL=58.03658.03658.03658.03658.036 5.X-Rs控制图

子样号X Rs

1 3.76-

2 3.490.27

3 3.750.26

4 3.660.09

5 3.620.04

6 3.640.02

7 3.590.05

8 3.580.01

9 3.670.09

10 3.630.04

11 3.670.04

12 3.630.04

13 3.660.03

14 3.810.151********

15 3.970.16

16 3.640.33

17 3.670.03

18 3.60.07

19 3.610.01

20 3.610

21 3.60.01

22 3.680.08

23 3.660.02

24 3.620.04

25 3.610.01平均数 3.65720.07875

X控制图:

CL=3.657 3.657 3.657 3.657 3.657 UCL=3.867 3.867 3.867 3.867 3.867 LCL=3.4470 3.447 3.447 3.447 3.447 R控制图

CL=0.0790.0790.0790.0790.079 ULC=0.2580.2580.2580.2580.258

样组号91011121314151617181920212223242526272829

相关主题
文本预览
相关文档 最新文档