專業(yè)數(shù)據(jù)分析培訓(xùn)

1、Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 J

2、an. 05Prepared by Wang Gang - 25 Jan. 05備注: 大樣本均數(shù)比較可使用Z檢驗.Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05Loop_HColumn1BinFrequency Cumul%5.440.00%5.83Mean5.284674.250.00%5.51Standard Error0.052274.50.00%5.51Median5.244.7513.33%5.04Mode5.45416.67

3、%5.28Standard Deviation0.286315.251050.00%5.67Sample Variance0.081975.5876.67%5.09Kurtosis0.256695.75593.33%5.16Skewness0.429562100.00%5.12Range1.36.250100.00%5.08Minimum4.696.50100.00%5.36Maximum5.996.750100.00%5.4Sum158.5470100.00%5.36Count307.250100.00%5.2Confidence Level(95.0%)0.106917.50100.00%

4、4.697.750100.00%5.36Upper SPEC Limit (USL)980100.00%5.63Lower SPEC Limit (LSL)48.250100.00%4.888.50100.00%5CP8.750100.00%5Potential Process Capability Index90100.00%5CPk5.2Process Capability Index5.125.595.435.085.165.45.992.911.50Histogram0246810124.004.505.005.506.006.507.007.508.008.509.00.00%20.

5、00%40.00%60.00%80.00%100.00%120.00%Prepared by Wang Gang - 25 Jan. 05Loop_HColumn1BinFrequency Cumulative %6.140.00%5.99Mean5.9484.250.00%5.95Standard Error0.046454.50.00%6.26Median5.954.750.00%6.3Mode5.9550.00%5.28Standard Deviation0.254415.250.00%5.63Sample Variance0.064735.526.67%5.67Kurtosis0.35

6、5085.75523.33%5.71Skewness-0.552461263.33%5.71Range1.16.25786.67%5.95Minimum5.286.54100.00%6.14Maximum6.386.750100.00%5.95Sum178.4470100.00%5.91Count307.250100.00%6.18Confidence Level(95.0%)0.0957.50100.00%5.477.750100.00%5.75Upper SPEC Limit (USL)980100.00%5.83Lower SPEC Limit (LSL)48.250100.00%5.9

7、98.50100.00%6.38CP8.750100.00%6.14Potential Process Capability Index90100.00%6.3CPk5.99Process Capability Index5.876.226.065.835.796.145.953.282.55Histogram024681012144.004.505.005.506.006.507.007.508.008.509.00Frequency.00%20.00%40.00%60.00%80.00%100.00%120.00%Prepared by Wang Gang - 25 Jan. 05Hist

8、ogram0246810124.004.505.005.506.006.507.007.508.008.509.00.00%20.00%40.00%60.00%80.00%100.00%120.00%Histogram024681012144.004.505.005.506.006.507.007.508.008.509.00Frequency.00%20.00%40.00%60.00%80.00%100.00%120.00%Prepared by Wang Gang - 25 Jan. 05下規(guī)格限 LSL: Lower Specification Limit 上規(guī)格限 USL: Upper

9、 Specification Limit中心線 CL: Center LinePrepared by Wang Gang - 25 Jan. 05PPM: Piece Per MillionDPMO: Defect Per Million OpportunityPrepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05Prepared by Wang Gang - 25 Jan. 05USL:Upper SPEC LimitLSL:Lower SPEC Limit:Sigma (Standard Deviation)

10、CP:Potential Process Capability IndexCPk:Process Capability IndexCPk= minCP =USL - LSL6USL - u3u - LSL3,6: CPk 1.67Prepared by Wang Gang - 25 Jan. 05Histogram0246810124.004.505.005.506.006.507.007.508.008.509.00.00%20.00%40.00%60.00%80.00%100.00%120.00%Histogram024681012144.004.505.005.506.006.507.0

11、07.508.008.509.00Frequency.00%20.00%40.00%60.00%80.00%100.00%120.00%Prepared by Wang Gang - 25 Jan. 051. efine2. easure3. nalyze4. mprove5. ontrolPrepared by Wang Gang - 25 Jan. 05LSLUSLUCLLCLUCL=u+3LCL= u -3uPrepared by Wang Gang - 25 Jan. 05LSLUSLUCLLCLUCL=u+3=5.95+3*0.25=6.70LCL= u -3=5.95+3*0.25

12、=5.20U=5.95Histogram024681012144.004.505.005.506.006.507.007.508.008.509.00Frequency.00%20.00%40.00%60.00%80.00%100.00%120.00%USL=9.00LSL=4.00Prepared by Wang Gang - 25 Jan. 05LSLUSLUCLLCLPrepared by Wang Gang - 25 Jan. 05LSLUSLUCLLCLPrepared by Wang Gang - 25 Jan. 05LSLUSLUCLLCLPrepared by Wang Gang - 25 Jan. 05LSLUSLUCLLCLPre