Minitab Cookbook

Cover......Page 1
Copyright......Page 3
Credits......Page 4
About the Author......Page 5
About the Reviewers......Page 6
www.PacktPub.com......Page 8
Table of Contents......Page 10
Preface......Page 14
Chapter 1: Worksheet, Data Management, and
the Calculator......Page 20
Opening an Excel file in Minitab......Page 21
Opening data from Access using ODBC......Page 24
Stacking several columns together......Page 25
Stacking blocks of columns at the same time......Page 28
Transposing the columns of a worksheet......Page 30
Splitting a worksheet by categorical column......Page 31
Creating a subset of data in a new worksheet......Page 32
Extracting values from a date/time column......Page 35
Calculator – basic functions......Page 37
Calculator – using an if statement......Page 39
Coding a numeric column to text values......Page 41
Cleaning up a text column with the calculator......Page 43
Introduction......Page 46
Finding the Tally of a categorical column......Page 47
Building a table of descriptive statistics......Page 49
Creating Pareto charts......Page 50
Creating bar charts of categorical data......Page 52
Creating a bar chart with a numeric response......Page 55
Creating a scatterplot of two variables......Page 56
Generating a paneled boxplot......Page 59
Finding the mean to a 95 percent confidence on interval plots......Page 62
Using probability plots to check the distribution of two sets of data......Page 64
Creating a layout of graphs......Page 65
Creating a time series plot......Page 67
Adding a secondary axis to a time
series plot......Page 69
Chapter 3: Basic Statistical Tools......Page 72
Producing a graphical summary of data......Page 73
Checking if data follows a normal distribution......Page 76
Comparing the population mean to a target with a 1-Sample t-test......Page 77
Using the Power and Sample Size tool for a 1-Sample t-test......Page 80
Using the Assistant menu for a 1-Sample t-test......Page 81
Looking for differences in the population means between two samples with a 2-Sample t-test......Page 83
Using the Power and Sample Size tool for a 2-Sample t-test......Page 85
Using the Assistant menu to run the 2-Sample t-test......Page 86
Finding critical t-statistics using the probability distribution plot......Page 87
Finding correlation between multiple variables......Page 88
Using the 1 Proportion test......Page 90
Graphically presenting the 1 Proportion test......Page 91
Using the Power and Sample Size tool for a 1 Proportion test......Page 92
Testing two population proportions with the 2 Proportions test......Page 93
Using the Power and Sample Size tool for a 2 Proportions test......Page 95
Using the Assistant menu to run a 2 Proportions test......Page 96
Finding the sample size to estimate a mean to a given margin of error......Page 97
Using Cross tabulation and Chi-Square......Page 98
Using equivalence tests to prove zero difference between the mean and a target......Page 100
Calculating the sample size for a 1-Sample equivalence test......Page 101
Chapter 4: Using Analysis
of Variance......Page 104
Introduction......Page 105
Using a one-way ANOVA with unstacked columns......Page 106
Calculating power for the one-way ANOVA......Page 108
Using Assistant to run a one-way ANOVA......Page 110
Testing for equal variances......Page 112
Analyzing a balanced design......Page 114
Entering random effects model......Page 116
Using GLM for unbalanced designs......Page 121
Analyzing covariance......Page 126
Analyzing a fully nested design......Page 129
The repeated measures ANOVA – using a mixed effects model......Page 130
Finding the critical F-statistic......Page 134
Introduction......Page 138
Visualizing simple regressions with fitted line plots......Page 140
Using the Assistant tool to run a regression......Page 142
Multiple regression with linear predictors......Page 145
Model selection tools – the best subsets regression......Page 148
Model selection tools – the stepwise regression......Page 152
Binary logistic regression......Page 154
Fitting a nonlinear regression......Page 159
Chapter 6: Understanding
Process Variation
with Control Charts......Page 166
Xbar-R charts and applying stages to a control chart......Page 167
Using an Xbar-S chart......Page 170
Using I-MR charts......Page 174
Using the Assistant tool to create control charts......Page 178
Attribute charts' P (proportion) chart......Page 181
Testing for overdispersion and Laney
P' chart......Page 184
Creating a u-chart......Page 186
Testing for overdispersion and Laney U' chart......Page 188
Using CUSUM charts......Page 189
Finding small shifts with EWMA......Page 190
Control charts for rare events – T charts......Page 193
Rare event charts – G charts......Page 195
Chapter 7: Capability, Process Variation, and Specifications......Page 198
Introduction......Page 199
A capability and control chart report using the capability analysis sixpack......Page 200
Capability analysis for normally distributed data......Page 202
Capability analysis for nonnormal distributions......Page 206
Using a Box-Cox transformation for capability......Page 211
Using a Johnson transformation for capability......Page 213
Using the Assistant tool for short-run capability analysis......Page 215
Comparing the capability of two processes using the Assistant tool......Page 217
Creating an acceptance sampling plan for variable data......Page 219
Creating an acceptance sampling plan for attribute data......Page 221
Comparing a previously defined sampling plan – C = 0 plans......Page 223
Generating run charts......Page 226
Generating tolerance intervals for summarized data......Page 228
Datasets that do not transform or fit any distribution......Page 229
Introduction......Page 232
Analyzing a Type 1 Gage study......Page 233
Creating a Gage R&R worksheet......Page 235
Analyzing a crossed Gage R&R study......Page 237
Studying a nested Gage R&R......Page 241
Checking Gage linearity and bias......Page 242
Expanding a Gage study with extra factors......Page 244
Studying a go / no go measurement system......Page 247
Using the Assistant tool for Gage R&R......Page 248
Attribute Gage study from the Assistant menu......Page 250
Introduction......Page 254
Finding the principal components of a set of data......Page 255
Using factor analysis to identify the underlying factors......Page 261
Analyzing consistency of a test paper using item analysis......Page 265
Finding similarity in results by rows using cluster observations......Page 266
Finding similarity across columns using cluster variables......Page 269
Identifying groups in data using cluster K-means......Page 271
The discriminant analysis......Page 274
Analyzing two-way contingency tables with a simple correspondence analysis......Page 277
Studying complex contingency tables with a multiple correspondence analysis......Page 282
Introduction......Page 286
Fitting a trend to data......Page 287
Fitting to seasonal variation......Page 290
Time series predictions without trends or seasonal variations......Page 294
Introduction......Page 298
Exec macros to repeat simple commands......Page 301
Building a Global macro to create a custom graph layout......Page 305
Obtaining input from the session window with a Global macro......Page 311
Creating a Local macro......Page 314
Local macros with subcommands, submacros, and control statements......Page 318
The Project Manager toolbar......Page 322
Index......Page 328