Data Analysis with Microsoft Excel: Updated for Office 2007

508 Statistical Methods The range names have been defi ned for the workbook in Table 12-6. Table 12-6 The Steel Workbook Range N ...

Chapter 12 Quality Control 509 As shown in Figure 12-14, the lower control limit is 0.01069, or a defect percentage of about 1%. ...

510 Statistical Methods We can also create a moving range chart of the moving range values, that is, the range between consecuti ...

Chapter 12 Quality Control 511 The range names are shown in Table 12-7. Table 12-7 The Strength Workbook Range Name Range Descri ...

512 Statistical Methods The chart shown in Figure 12-16 gives the values of the individual observations (not the moving averages ...

Chapter 12 Quality Control 513 The Pareto Chart After you have determined that your process is resulting in an unusual number of ...

514 Statistical Methods The following range names have been defined for the workbook in Figure 12-18: Table 12-8 The Powder Work ...

Chapter 12 Quality Control 515 Figure 12-19 The Create a Pareto Chart dialog box 7 Click OK. Excel generates the chart shown in ...

516 Statistical Methods The Pareto chart displayed in Figure 12-20 shows that a majority of the rejects come from a few heads. F ...

Chapter 12 Quality Control 517 True or false, and why? The purpose of statistical process control is to eliminate all variation ...

518 Statistical Methods determine whether the delivery pro- cess is in control. If not, suggest some special causes that might e ...

Chapter 12 Quality Control 519 is out of control? What factors, if any might have contributed to this? c. Save your changes to t ...

520 Statistical Methods The Tornado workbook records the number of tornadoes of various lev- els of severity in Kansas from 195 ...

521 APPENDIX Excel Reference Contents The Excel Reference contains the following: Excel’s Data Analysis ToolPak Excel’s Math and ...

522 The Analysis ToolPak add-ins that come with Excel enable you to perform basic statistical analysis. None of the output from ...

Excel Reference 523 New Workbook Click to send output to a new workbook. Anova: Single Factor The Anova: Single Factor command c ...

524 Anova: Two-Factor With Replication The Anova: Two-Factor With Replication command calculates the two-way analysis of varianc ...

Excel Reference 525 Anova: Two-Factor Without Replication The Anova: Two-Factor Without Replication command calculates the two- ...

526 Correlation The Correlation command creates a table of the Pearson correlation coef- fi cient for values in rows or columns ...

Excel Reference 527 Covariance The Covariance command creates a table of the covariance for values in rows or columns on the wor ...