Unleash the full improvement potential of Six Sigma statistical techniques by using Excel and/or Minitab to design experiments, sample strategies, compare variances, and conduct analyses.
Six Sigma Statistics with Excel and Minitab, Second Edition shows how to create reports, run analyses, and interpret results using these two widely used statistical software tools. This practical guide provides the perfect toolbox of theory, illustrations, explanations, exercises, and case studies both in the book and on an affiliated website to show how to use Excel and Minitab in conjunction with Six Sigma for an ideal improvement package. It reviews the quality tools that require Excel and/or Minitab, including measurement system analysis, SPC, the Taguchi method, and process capability analysis.
- Affiliated website contains all 75 Excel/Minitab examples from book, plus at least 25 extras that aren’t included in the print version
- Written by a Six Sigma Master Black Belt known for his expertise with statistics
- Includes detailed graphics and real-world examples that can be applied to any industry
Ch 1 IntroductionIntroduction to Statistics * What is Six Sigma *Six Sigma, a Statistical Definition * Statistics, Six Sigma and Quality controlCh 2 Intro to Minitab and ExcelNavigating in Minitab * Excel for Statistical Analysis * Charts and Graphs * Excel Applications * Minitab Applications *ExamplesCh 3 Descriptive StatisticsMeasures of Central Tendency * Measures of Dispersion * Range *Mean Deviation * Variance * Standard Deviation * Ch 4 Introduction to ProbabilityDiscrete and continuous distributions * Discrete Distributions * Continuous DistributionsCh 5 Sampling DistributionCentral Limit Theorem* Sampling Distribution for the Mean * Sampling Distribution for Proportions * Estimating Populations with Large Sample sizes * Estimating Populations with small sample sizes and sigma unknown * Estimating Sample sizes * Minitab and Excel exercisesCh 6 Hypothesis Testing How to conduct a Hypothesis Test *Testing for a population mean * Testing for proportions * Statistical Inference about two PopulationsCh 7 Statistical Process Control How to build a control Chart * The WECO Rules * Control Charts in Minitab * Types of Control ChartsCh 8 Process Capability AnalysisDefinition of Process Capability Analysis * Process Capability with Normal Data * Process Capability in Minitab Ch 9 Analysis Of VarianceCompletely Randomized Experimental Design One Way ANOVA * The Randomized Block Design Two Way ANOVA* Analysis of Mean ANOMCh 10 Regression AnalysisSimple Linear Regression and Correlation Analysis * Multiple Regression AnalysisCh 11 Design of ExperimentFactorial Design with Two Factors * Factorial Design with More than Two Factors * Fractional Factorial DesignsCh 12 Taguchi MethodTaguchi’s Loss Function * Taguchi’s DesignCh 13 Measurement System AnalysisMSA Overview * Variations due to Precision * Variations due to AccuracyCh 14 Nonparametric Statistics Chi Square test * Run Test * Friedman Test * Mann Whitney test * Krustal-Wallis TestCh 15 Basic Quality ToolsPareto Analysis * Cause and Effect Diagram
Other versions by this Author