PPK,Cpk,SPC控制图,直方图自动计算

双侧公差限'01 PSW'!A21单侧公差限 (下公差)'07 CAV'!A6'01 PSW'!H6'01 PSW'!A6单侧公差限（上公差）'01 PSW'!A14'01 PSW'!D10'01 PSW'!A8日期部门过程信息 地点零件设备/量具尺寸工厂零件号图号量具描述规格下公差12.912.7目标值13.002.00 12.993.00 4.00 5.00 6.00 7.00 12.98均值212.973456712.962.00 12.953.00 4.00 5.00 6.00 7.00 12.976212.94统计描述零件描述DOME LAMP SPRING CLIP分布趋势X ChartR Chart测量数量工程变更等级上升RUN LENGTH33Lower spec limit (LSL)设备 HOW MANY RUNS22Nominal单位g下降RUN LENGTH32Upper spec limit (USL)0.00.0HOW MANY RUNS46Total sum12.9上公差13.1界限外11Average readings ( X )Maximum12.96 均值(X chart)MinimumReadings below LSL8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 Readings above USLAverage Range (R)D2 Value (n=5)Upper capability index (CPU)Lower capability index (CPL)8910111213141516171819202122232425Capability index (Cp)Process Capability (Cpk)Capability ratio (CR)Std Deviation (n-1)MZ80238.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 Std Deviation (n)Variance (n-1)Variance (n)Performance index (PP)Performance ratio (PR)Performance index (Ppk)8910111213141516171819202122232425值12512.700012.900013.10001,622.100012.976813.000012.9400000.02442.33003.92158.81076.36613.92150.85280.01200.01200.00010.00015.55330.18013.420912.931234567直方图60Data PointsData ValuesUCLxAveXLCLx13.00 00.1 极差(R chart)0.1 50484020.1 3456789101112131415161718192021222324253028极差频数0.0 0.0 0.0 0.0 2014181023456789101112131415161718192021222324251000160000.0 12345678910111213141516171819202122232425Data PointsData ValuesUCLrAveRLCLr0.0244567891011121314151617181920子组2122Data PointsDistribution Shapen12345AverageRange1234232425N12.9812.9813.0012.9912.9712.980.0O12.9412.9612.9612.9613.0012.960.1T12.9912.9812.9712.9513.0012.960.1E12.9912.9812.9712.9513.0012.980.1S13.0012.9712.9813.0012.9512.980.112.9812.9612.9812.9712.9812.970.012.9512.9812.9712.9612.9712.970.012.9712.9812.9712.9812.9712.970.012.9812.9712.9612.9812.9712.970.012.9813.0012.9912.9712.9812.980.012.9812.9612.9812.9912.9812.980.012.9812.9712.9812.9712.9712.970.013.0012.9912.9912.9812.9812.990.012.9912.9812.9812.9912.9912.990.012.9912.9812.9912.9812.9912.990.012.9812.9712.9712.9812.9812.980.012.9612.9512.9612.9512.9612.960.013.0012.9912.9712.9812.9812.980.012.9912.9812.9612.9812.9712.980.012.9712.9812.9812.9712.9812.980.012.9912.9812.9812.9912.9812.980.012.9712.9812.9712.9812.9712.970.012.9812.9612.9712.9612.9812.970.012.9812.9712.9812.9612.9812.970.012.9913.0012.9812.9812.9712.980.0编制：Filename: 259334629.xls / SPC

审批：