专业数据分析培训概要

PreparedbyWangGang-25Jan.‘05DataAnalysisandSPCBasicTobeintroduced…1.Excel中数据分析工具2.描述统计3.直方图4.假设检验5.SixSigmaConcept6.SPCPreparedbyWangGang-25Jan.‘051.DataAnalysisBasicPreparedbyWangGang-25Jan.‘051.DataAnalysisBasicPreparedbyWangGang-25Jan.‘051.DataAnalysisBasicPreparedbyWangGang-25Jan.‘051.DataAnalysisBasicPreparedbyWangGang-25Jan.‘051.DataAnalysisBasicPreparedbyWangGang-25Jan.‘051.DataAnalysisBasicPreparedbyWangGang-25Jan.‘051.DataAnalysisBasic两个样本均数比较的目的是推断两总体均数是否相同.PreparedbyWangGang-25Jan.‘051.DataAnalysisBasic2.当两样本异方差时:2.当两样本等方差时:1.先做F-检验双样本方差分析PreparedbyWangGang-25Jan.‘051.DataAnalysisBasic备注:大样本均数比较可使用Z检验.PreparedbyWangGang-25Jan.‘051.DataAnalysisBasicPreparedbyWangGang-25Jan.‘05LoopHeight2.TwoexamplesofDataAnalysisPreparedbyWangGang-25Jan.‘052.TwoexamplesofDataAnalysisLoop_HColumn1BinFrequencyCumul%5.440.00%5.83Mean5.284674.250.00%5.51StandardError0.052274.50.00%5.51Median5.244.7513.33%5.04Mode5.45416.67%5.28StandardDeviation0.286315.251050.00%5.67SampleVariance0.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.2ConfidenceLevel(95.0%)0.106917.50100.00%4.697.750100.00%5.36UpperSPECLimit(USL)980100.00%5.63LowerSPECLimit(LSL)48.250100.00%4.888.50100.00%5CP8.750100.00%5PotentialProcessCapabilityIndex90100.00%5CPk5.2ProcessCapabilityIndex5.125.595.435.085.165.45.992.911.50Histogram0246810124.004.505.005.506.006.507.007.508.008.509.00.00%20.00%40.00%60.00%80.00%100.00%120.00%Example1PreparedbyWangGang-25Jan.‘052.TwoexamplesofDataAnalysisLoop_HColumn1BinFrequencyCumulative%6.140.00%5.99Mean5.9484.250.00%5.95StandardError0.046454.50.00%6.26Median5.954.750.00%6.3Mode5.9550.00%5.28StandardDeviation0.254415.250.00%5.63SampleVariance0.064735.526.67%5.67Kurtosis0.355085.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.18ConfidenceLevel(95.0%)0.0957.50100.00%5.477.750100.00%5.75UpperSPECLimit(USL)980100.00%5.83LowerSPECLimit(LSL)48.250100.00%5.998.50100.00%6.38CP8.750100.00%6.14PotentialProcessCapabilityIndex90100.00%6.3CPk5.99ProcessCapabilityIndex5.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%Example2PreparedbyWangGang-25Jan.‘05Histogram024681012.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%2.TwoexamplesofDataAnalysisExample1Example2PreparedbyWangGang-25Jan.‘053.SixSigmaConcept下规格限LSL:LowerSpecificationLimit上规格限USL:UpperSpecificationLimit中心线CL:CenterLinePreparedbyWangGang-25Jan.‘053.462335621046680733085372PPM(DPMO)SigmaLevel3.SixSigmaConceptPPM:PiecePerMillionDPMO:DefectPerMillionOpportunityPreparedbyWangGang-25Jan.‘053.SixSigmaConceptPreparedbyWangGang-25Jan.‘053.SixSigmaConceptPreparedbyWangGang-25Jan.‘05USL:UpperSPECLimitLSL:LowerSPECLimit:Sigma(StandardDeviation)CP:PotentialProcessCapabilityIndexCPk:ProcessCapabilityIndexCPk=minCP=USL-LSL6USL-u3u-LSL3,6:CPk1.673.SixSigmaConceptPreparedbyWangGang-25Jan.‘05Histogram024681012.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%3.SixSigmaConceptPreparedbyWangGang-25Jan.‘053.SixSigmaConceptDMAICApproach1.Define2.Measure3.Analyze4.Improve5.ControlPreparedbyWangGang-25Jan.‘054.StatisticalProcessControlSPCLSLUSLUCLLCLCLTimeUCL=u+3LCL=u-3uPreparedbyWangGang-25Jan.‘054.StatisticalProcessControlSPCLSLUSLUCLLCLCLTimeUCL=u+3=5.95+3*0.25=6.70LCL=u-3=5.95+3*0.25=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.00PreparedbyWangGang-25Jan.‘054.StatisticalProcessControlSPCLSLUSLUCLLCLCLTimePreparedbyWangGang-25Jan.‘054.StatisticalProcessControlSPCLSLUSLUCLLCLCLTimePreparedbyWangGang-25Jan.‘054.StatisticalProcessControlSPCLSLUSLUCLLCLCLTimePreparedbyWangGang-25Jan.‘054.StatisticalProcessControlSPCLSLUSLUCLLCLCLTimePreparedbyWangGang-25Jan.‘054.StatisticalProcessControlSPCLSLUSLUCLLCLCLTimePreparedbyWangGang-25Jan.‘054.StatisticalProcessControlSPCLSLUSLUCLLCLCLTimePreparedbyWangGang-25Jan.‘05DataAnalysisandSPCBasicIntroduced…1.Excel中数据分析工具2.描述统计3.直方图4.假设检验5.SixSigmaConcept6.SPCPreparedbyWangGang-25Jan.‘05Anyinput?PreparedbyWangGang-25Jan.‘05Thankyou![e-mail]