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

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

《CPK原始数据自动生成2018.xls》由会员分享，可在线阅读，更多相关《CPK原始数据自动生成2018.xls（9页珍藏版）》请在冰豆网上搜索。

序号1122334455667788991010尺尺寸寸35.335.3135.235.1635.1935.1935.235.1935.2235.235.1835.21上上差差00235.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倍倍数数（默默认认66）66535.1935.235.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.1535.2235.2135.2335.235.1935.2135.18小小数数位位数数22435.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.18极极差差均均值值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.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.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.1835.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.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.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.211223344556677889935.1735.1835.1735.235.2135.2135.2135.235.2135.235.2335.2235.2235.2435.235.1835.2135.2335.1735.1635.2135.2135.2135.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.1835.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