Six Sigma Statistics with EXCEL and MINITAB

Front Cover
McGraw Hill Professional, Jul 18, 2007 - Business & Economics - 374 pages
3 Reviews

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
Appendix 6 F Table 945 005
367
Index
369
For Download
375
Copyright

Other editions - View all

Common terms and phrases

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.

About the author (2007)

Issa Bass is a Six Sigma Master Black Belt and Six Sigma project leader for Kenco Group, Inc. He is the founding editor of SixSigmaFirst.com.

Bibliographic information