CPK原始数据自动生成2018.xls

1、序号1 12 23 34 45 56 67 78 89 91010尺尺寸寸35.335.3135.235.1635.1935.1935.235.1935.2235.235.1835.21上上差差0 0235.1835.2435.2235.1735.2335.2135.1935.2235.1935.17下下差差-0.2-0.2335.1935.2135.235.2235.235.2135.2135.1935.1835.21公公差差范范围围0.2435.1735.1535.2235.235.1835.1835.1935.2135.1635.19倍倍数数（默默认认6 6）6 6535.1935.23

2、5.2135.235.1835.235.235.1935.235.19预预计计CPKCPK值值1.851.85极差0.030.090.030.050.050.030.030.030.040.04尺尺寸寸上上限限35.3序号1111121213131414151516161717181819192020尺尺寸寸下下限限35.1135.1935.2135.2235.2335.1835.1935.2335.1935.235.17均均值值35.2235.235.1635.2235.1935.235.2335.1935.1535.2135.21标标准准差差0.018018018335.235.1735.

3、1535.2235.2135.2335.235.1935.2135.18小小数数位位数数2 2435.1835.235.2135.2335.2235.235.2335.235.2235.2标标准准差差0.019104804535.235.1935.1935.2135.1935.2235.2435.1835.1835.19平平均均数数35.19792极差0.020.050.070.040.040.040.050.050.040.04实实际际CPKCPK值值1.8980序号21212222232324242525实实际际PPKPPK值值1.7085135.2135.1835.1835.1835.1

4、8极极差差均均值值0.04235.235.2135.235.1835.19335.2435.235.1835.235.19备注：红色字体可修改。435.2335.1935.2235.1935.19535.2235.2135.1935.235.18极差0.040.030.040.020.012.3262.326序序号号尺寸35.3 随机数值35.17 保留n位小数且为偶数35.170.0301上差035.235.20.0702下差-0.235.1735.170.0503公差范围0.235.235.20.0204倍数（默认6）635.235.20.0705预计CPK值1.8535.1835.180

5、.020极差尺寸上限35.335.23350.080序序号号尺寸下限35.135.1635.160.0301均值35.235.1835.180.0502标准差0.01801801835.1935.190.0503小数位数235.1735.170.0304标准差0.01878297135.2235.220.0305平均数35.1983235.2135.210.030极差实际CPK值1.815035.2235.220.060序序号号实际PPK值1.744835.1935.190.0201极差均值0.04200035.235.20.040235.2235.220.0303备注：红色字体可修改。35.

6、2135.210.030435.2135.210.020535.235.20.040极差35.2135.210.04035.2435.240.08035.2135.210.04035.2135.210.04035.1735.170.05035.2135.2135.235.235.2135.2135.1935.1935.235.235.2135.2135.1835.1835.235.235.1535.1535.2335.2335.235.235.2135.2135.1935.1935.235.235.1835.1835.2135.2135.2335.2335.1835.1835.1835.183

7、5.235.235.235.235.1635.1635.235.235.1535.1535.1935.1935.235.235.235.235.2335.2335.235.235.2335.2335.2235.2235.1935.1935.2235.2235.1935.1935.2235.2235.1935.1935.235.235.235.235.2235.2235.1935.1935.1735.1735.2135.2135.235.235.235.235.2335.2335.235.235.2135.2135.1935.1935.235.235.235.235.2135.2135.235.

8、235.1935.1935.2335.2335.235.235.2235.2235.2335.2335.2335.2335.235.235.235.235.1935.1935.235.235.2135.2135.1935.1935.1835.1835.1935.1935.1735.1735.1835.1835.1735.1735.1935.1935.235.235.235.235.2235.2235.235.235.1835.1835.1835.1835.2135.2135.2135.2135.2235.2235.1935.1935.1935.1935.2335.2335.1835.1835.

9、1535.1535.1835.1835.2235.2235.2135.2135.1835.1835.1935.1935.2135.2135.1835.1835.1735.1735.2135.2135.235.235.235.235.1935.1935.1735.1735.2235.2235.1835.1835.235.21 12 23 34 45 56 67 78 89 935.1735.1835.1735.235.2135.2135.2135.235.2135.235.2335.2235.2235.2435.235.1835.2135.2335.1735.1635.2135.2135.213

10、5.2135.235.1935.1835.235.1835.2235.2135.2135.1935.1535.235.1835.235.1935.1935.235.1735.235.2335.1835.20.030.070.050.020.070.020.080.030.0511111212131314141515161617171818191935.235.2235.1935.1735.235.2135.2235.1935.1935.235.1935.235.2135.2135.235.2335.235.1735.2335.2235.235.235.1935.1935.2335.2135.1

11、835.235.1935.2235.235.235.2335.235.1935.1735.2335.2235.1935.2335.235.235.235.1835.190.030.030.030.060.020.040.030.030.022121222223232424252535.1835.1935.2235.1835.1935.2135.2335.2135.1735.1735.2135.1835.1835.2135.2235.2235.1535.1935.235.1835.1935.1835.2135.235.20.040.080.040.040.05101035.235.1635.235.1535.190.05202035.235.235.2235.235.180.04