# Six Sigma Statistics with EXCEL and MINITAB

McGraw Hill Professional, Jul 18, 2007 - Business & Economics - 374 pages

Master the Statistical Techniques for Six Sigma Operations, While Boosting Your Excel and Minitab Skills!

Now with the help of this “one-stop” resource, operations and production managers can learn all the powerful statistical techniques for Six Sigma operations, while becoming proficient at Excel and Minitab at the same time.

Six Sigma Statistics with Excel and Minitab offers a complete guide to Six Sigma statistical methods, plus expert coverage of Excel and Minitab, two of today's most popular programs for statistical analysis and data visualization.

Written by a seasoned Six Sigma Master Black Belt, the book explains how to create and interpret dot plots, histograms, and box plots using Minitab...decide on sampling strategies, sample size, and confidence intervals...apply hypothesis tests to compare variance, means, and proportions...conduct a regression and residual analysis...design and analyze an experiment...and much more.

Filled with clear, concise accounts of the theory for each statistical method presented, Six Sigma Statistics with Excel and Minitab features:

• Easy-to-follow explanations of powerful Six Sigma tools
• A wealth of exercises and case studies
• 200 graphical illustrations for Excel and Minitab

Essential for achieving Six Sigma goals in any organization, Six Sigma Statistics with Excel and Minitab is a unique, skills-building toolkit for mastering a wide range of vital statistical techniques, and for capitalizing on the potential of Excel and Minitab.

Six Sigma Statistical with Excel and Minitab offers operations and production managers a complete guide to Six Sigma statistical techniques, together with expert coverage of Excel and Minitab, two of today's most popular programs for statistical analysis and data visualization.

Written by Issa Bass, a Six Sigma Master Black Belt with years of hands-on experience in industry, this on-target resource takes readers through the application of each Six Sigma statistical tool, while presenting a straightforward tutorial for effectively utilizing Excel and Minitab. With the help of this essential reference, managers can:

• Acquire the basic tools for data collection, organization, and description
• Learn the fundamental principles of probability
• Create and interpret dot plots, histograms, and box plots using Minitab
• Decide on sampling strategies, sample size, and confidence intervals
• Apply hypothesis tests to compare variance, means, and proportions
• Stay on top of production processes with statistical process control
• Use process capability analysis to ensure that processes meet customers' expectations
• Employ analysis of variance to make inferences about more than two population means
• Conduct a regression and residual analysis
• Design and analyze an experiment

In addition, Six Sigma Statistics with Excel and Minitab enables you to develop a better understanding of the Taguchi Method...use measurement system analysis to find out if measurement processes are accurate...discover how to test ordinal or nominal data with nonparametric statistics...and apply the full range of basic quality tools.

Filled with step-by-step exercises, graphical illustrations, and screen shots for performing Six Sigma techniques on Excel and Minitab, the book also provides clear, concise explanations of the theory for each of the statistical tools presented.

Authoritative and comprehensive, Six Sigma Statistics with Excel and Minitab is a valuable skills-building resource for mastering all the statistical techniques for Six Sigma operations, while harnessing the power of Excel and Minitab.

### What people are saying -Write a review

User Review - Flag as inappropriate

The boob having very usefull information ..Manoj Kumar

User Review - Flag as inappropriate

sss

### Contents

 Chapter 1 Introduction 1 Chapter 2 An Overview of Minitab and Microsoft Excel 23 Chapter 3 Basic Tools for Data Collection Organization and Description 41 Chapter 4 Introduction to Basic Probability 73 Chapter 5 How to Determine Analyze and Interpret Your Samples 99 Chapter 6 Hypothesis Testing 121 Chapter 7 Statistical Process Control 145 Chapter 8 Process Capability Analysis 171
 Is Your Measurement Process Lying to You? 303 Chapter 14 Nonparametric Statistics 329 Chapter 15 Pinpointing the Vital Few Root Causes 347 Appendix 1 Binominal Table Px subnCsubx psupxqsupnx 354 Appendix 2 Poisson Table Px 955supxesup955x 357 Appendix 3 Normal Z Table 364 Appendix 4 Students t Table 365 Appendix 5 ChiSquare Table 366

 Chapter 9 Analysis of Variance 203 Chapter 10 Regression Analysis 231 Chapter 11 Design of Experiment 275 Chapter 12 The Taguchi Method 289

### Popular passages

Page 34 - Insert Function Search for a function: (Type a brief description of what you want to do and then click Go Or select a category...
Page 54 - The coefficient of variation is the ratio of the standard deviation to the mean...
Page 39 - Factor Anova: Two-Factor With Replication Anova: Two-Factor Without Replication Correlation Covariance Descriptive Statistics Exponential Smoothing F-Test Two-Sample for Variances Fourier Analysis Histogram OK v Cancel Help These options will be examined more extensively throughout this book.
Page 235 - Chart Wizard - Step 1 of 4 - Chart Type Standard Types | Custom Types | Chart type: Chart sub-type: Clustered Column.
Page 45 - Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers.
Page 50 - Therefore, the standard deviation is the square root of the sum of the squares of the deviations from the mean, divided by the number of observations.
Page 246 - Exponential Smoothing F-Test: Two-Sample for Variances Fourier Analysis Histogram Moving Average Random Number Generation Rank and Percentile...
Page 17 - In quality control there are two important measures of variability, the range and the standard deviation. The range is the difference between the largest and smallest values within a sample.
Page 122 - I error is designated as a and the probability of making a Type II error is designated as ft.
Page 61 - Array 2 is a second cell range of values. The values should be numbers, names, arrays, or references that contain numbers. Formula rssult =0.847893482 OK Cancel (b) Use the Chart Wizard to plot an (XY) Scatter diagram.