CPK-PPK计算表格

#N/APartCertification双侧公差单向公差（最小）单向公差（最大）3'01PSW'!A21'07CAV'!A6'01PSW'!H6'01PSW'!A6'01PSW'!A14'01PSW'!D10'01PSW'!A8Significanttrendsofdatapoints:XChartRChartLOCATION工厂公司名称Dept.部门QADate日期:2018.12.10IncreasingRUNLENGTH23PART零件号零件描述CAPHOWMANYRUNS41图号工程更改水平NADecreasingRUNLENGTH44TOOL工装号#Cavities模腔号1HOWMANYRUNS11DIMENSION描述Units单位MMOutofcontrollimits00SPEC名义值10.0PLUS上限0.1MINUS下限0.1Consecutivedatapointsaboveavg.#N/A#N/ALwrSpecLimit9.9NOMINAL10.0UprSpecLimit10.1Consecutivedatapointsbelowavg.#N/A#N/APROCESSCAPABILITYCERTIFICATIONREPORT过程能力研究报告Numberofreadingspersubgroup每子组零件读数PROCESSINFORMATION过程信息12345678912345678910.02842.00003.00004.00005.00006.00007.00008.00009.000010.000011.000012.000013.000014.000015.000016.000017.000018.000019.000020.000021.000022.000023.000024.000025.00009.995723456789101112131415161718192021222324259.96292.00003.00004.00005.00006.00007.00008.00009.000010.000011.000012.000013.000014.000015.000016.000017.000018.000019.000020.000021.000022.000023.000024.000025.00009.929.949.969.981010.0210.0412345678910111213141516171819202122232425平均值AverageDatapoints数据点Average(Xchart)平均值DataValuesUCLxAveXLCLx0.08242.00003.00004.00005.00006.00007.00008.00009.000010.000011.000012.000013.000014.000015.000016.000017.000018.000019.000020.000021.000022.000023.000024.000025.00000.032023456789101112131415161718192021222324250.00.010.020.030.040.050.060.070.080.0912345678910111213141516171819202122232425Range极差DataPoints数据点Range(Rchart)极差图DataValuesUCLrAveRLCLrTwosidedspec(bilateral)Onesided(MIN)Onesided(MAX)3数据更新Page1of2Filename:1587644199800/spcNAP4.5-1F-PCS12-1-99#N/APROCESSCAPABILITYCERTIFICATIONREPORT过程能力研究报告LOCATION工厂公司名称Dept.部门QADate日期:2018.12.10DESCRIPTIVESTATISTICSVALUESPART零件号零件描述CAPNumberofreadings30图号工程更改水平NALowerspeclimit(LSL)9.9000TOOL工装号#Cavities模腔号1Nominal10.0000DIMENSION描述0Units单位MMUpperspeclimit(USL)10.1000SPEC名义值10.0PLUS上限0.1MINUS下限0.1Totalsum299.8700LwrSpecLimit9.9NOMINAL10.0UprSpecLimit10.1Averagereadings(X)9.9957HISTOGRAMWITHOUTLIMITSHISTOGRAMWITHLIMITSMaximum10.0300LSLUSLMinimum9.9600ReadingsbelowLSL0ReadingsaboveUSL09.900010.1000AverageRange(R)0.0320D2Valuen=31.6930Uppercapabilityindex(CPU)1.8400Lowercapabilityindex(CPL)1.6871Capabilityindex(Cp)1.7635ProcessCapability(Cpk)1.6871Capabilityratio(CR)0.5670StdDeviation(n-1)0.0177StdDeviation(n)0.0175Variance(n-1)0.0003Variance(n)0.0003Performanceindex(PP)1.8779Performanceratio(PR)0.5325Performanceindex(Ppk)1.7966SUBGROUPSn1234567891011121314151617181920110.0109.99010.0309.9609.9909.99010.02010.01010.0009.970210.0309.9909.96010.01010.01010.0009.9709.99010.00010.00039.9809.9909.99010.0009.99010.00010.02010.0009.9809.990Average10.00679.999.99339.999.99679.996710.003310.09.99339.9867Range0.050.00.070.050.020.010.050.020.020.03n2122232425NOTES1Lessthan25subgroups,lastdatapointonX&Rchartarenotactualreadings23AverageRange123456789123456789202209704220123456789109.9579.9649.9719.9789.9859.9929.99910.00610.01310.02010.0276000622200005101520259.8409.8809.9209.96010.00010.04010.08010.12010.160READINGSREADINGSPage2of2Filename:1587644199800/spcNAP4.5-1F-PCS12-1-99