专业数据分析培训.ppt

* Prepared by Wang Gang - 25 Jan. ‘05 Data Analysis and SPC Basic To be introduced… Excel中数据分析工具 描述统计 直方图 假设检验 Six Sigma Concept SPC 1. Data Analysis Basic 1. Data Analysis Basic 1. Data Analysis Basic 1. Data Analysis Basic 1. Data Analysis Basic 1. Data Analysis Basic 1. Data Analysis Basic 两个样本均数比较的目的是推断两总体均数是否相同. 1. Data Analysis Basic 2. 当两样本异方差时: 2. 当两样本等方差时: 1. 先做F-检验 双样本方差分析 1. Data Analysis Basic 备注: 大样本均数比较可使用Z检验. 1. Data Analysis Basic Loop Height 2. Two examples of Data Analysis 2. Two examples of Data Analysis Example 1 2. Two examples of Data Analysis Example 2 Histogram 0 2 4 6 8 10 12 4.00 4.50 5.00 5.50 6.00 6.50 7.00 7.50 8.00 8.50 9.00 .00% 20.00% 40.00% 60.00% 80.00% 100.00% 120.00% 2. Two examples of Data Analysis Example 1 Example 2 3. Six Sigma Concept 下规格限 LSL: Lower Specification Limit 上规格限 USL: Upper Specification Limit 中心线 CL: Center Line 3.4 6? 233 5? 6210 4? 66807 3? 308537 2? PPM (DPMO) Sigma Level 3. Six Sigma Concept PPM: Piece Per Million DPMO: Defect Per Million Opportunity 3. Six Sigma Concept 3. Six Sigma Concept USL: Upper SPEC Limit LSL: Lower SPEC Limit ?: Sigma (Standard Deviation) CP: Potential Process Capability Index CPk: Process Capability Index CPk= min CP = USL - LSL 6? USL - u 3? u - LSL 3? , 6?: CPk 1.67 3. Six Sigma Concept Histogram 0 2 4 6 8 10 12 4.00 4.50 5.00 5.50 6.00 6.50 7.00 7.50 8.00 8.50 9.00 .00% 20.00% 40.00% 60.00% 80.00% 100.00% 120.00% 3. Six Sigma Concept 3. Six Sigma Concept DMAIC Approach 　1. Define 　2. Measure 　3. Analyze 　4. Improve 　5. Control 4. Statistical Process Control SPC LSL USL UCL LCL CL Time UCL=u+3? LCL= u -3? u 4. Statistical Process Control SPC LSL USL UCL LCL CL Time UCL=u+3?=5.95+3*0.25=6.70 LCL= u -3?=5.95+3*0.25=5.20 U=5.95 USL=9.00 LSL=4.00 * Prepared by Wang Gang - 25 Jan. ‘05