Minitab Cookbook

The Project Manager toolbar

Appendix A. Navigating Minitab and Useful Shortcuts

Local macros with subcommands submacros and control statements

Creating a Local macro

Obtaining input from the session window with a Global macro

Building a Global macro to create a custom graph layout

Exec macros to repeat simple commands

Introduction

Chapter 11. Macro Writing

Time series predictions without trends or seasonal variations

Fitting to seasonal variation

Fitting a trend to data

Introduction

Chapter 10. Time Series Analysis

Studying complex contingency tables with a multiple correspondence analysis

Analyzing two-way contingency tables with a simple correspondence analysis

The discriminant analysis

Identifying groups in data using cluster K-means

Finding similarity across columns using cluster variables

Finding similarity in results by rows using cluster observations

Analyzing consistency of a test paper using item analysis

Using factor analysis to identify the underlying factors

Finding the principal components of a set of data

Introduction

Chapter 9. Multivariate Statistics

Attribute Gage study from the Assistant menu

Using the Assistant tool for Gage R&R

Studying a go / no go measurement system

Expanding a Gage study with extra factors

Checking Gage linearity and bias

Studying a nested Gage R&R

Analyzing a crossed Gage R&R study

Creating a Gage R&R worksheet

Analyzing a Type 1 Gage study

Introduction

Chapter 8. Measurement Systems Analysis

Datasets that do not transform or fit any distribution

Generating tolerance intervals for summarized data

Generating run charts

Comparing a previously defined sampling plan – C = 0 plans

Creating an acceptance sampling plan for attribute data

Creating an acceptance sampling plan for variable data

Comparing the capability of two processes using the Assistant tool

Using the Assistant tool for short-run capability analysis

Using a Johnson transformation for capability

Using a Box-Cox transformation for capability

Capability analysis for nonnormal distributions

Capability analysis for normally distributed data

A capability and control chart report using the capability analysis sixpack

Introduction

Chapter 7. Capability Process Variation and Specifications

Rare event charts – G charts

Control charts for rare events – T charts

Finding small shifts with EWMA

Using CUSUM charts

Testing for overdispersion and Laney U' chart

Creating a u-chart

Testing for overdispersion and Laney P' chart

Attribute charts' P (proportion) chart

Using the Assistant tool to create control charts

Using I-MR charts

Using an Xbar-S chart

Xbar-R charts and applying stages to a control chart

Introduction

Chapter 6. Understanding Process Variation with Control Charts

Fitting a nonlinear regression

Binary logistic regression

Model selection tools – the stepwise regression

Model selection tools – the best subsets regression

Multiple regression with linear predictors

Using the Assistant tool to run a regression

Visualizing simple regressions with fitted line plots

Introduction

Chapter 5. Regression and Modeling the Relationship between X and Y

Finding the critical F-statistic

The repeated measures ANOVA – using a mixed effects model

Analyzing a fully nested design

Analyzing covariance

Using GLM for unbalanced designs

Entering random effects model

Analyzing a balanced design

Testing for equal variances

Using Assistant to run a one-way ANOVA

Calculating power for the one-way ANOVA

Using a one-way ANOVA with unstacked columns

Introduction

Chapter 4. Using Analysis of Variance

Calculating the sample size for a 1-Sample equivalence test

Using equivalence tests to prove zero difference between the mean and a target

Using Cross tabulation and Chi-Square

Finding the sample size to estimate a mean to a given margin of error

Using the Assistant menu to run a 2 Proportions test

Using the Power and Sample Size tool for a 2 Proportions test

Testing two population proportions with the 2 Proportions test

Using the Power and Sample Size tool for a 1 Proportion test

Graphically presenting the 1 Proportion test

Using the 1 Proportion test

Finding correlation between multiple variables

Finding critical t-statistics using the probability distribution plot

Using the Assistant menu to run the 2-Sample t-test

Using the Power and Sample Size tool for a 2-Sample t-test

Looking for differences in the population means between two samples with a 2-Sample t-test

Using the Assistant menu for a 1-Sample t-test

Using the Power and Sample Size tool for a 1-Sample t-test

Comparing the population mean to a target with a 1-Sample t-test

Checking if data follows a normal distribution

Producing a graphical summary of data

Introduction

Chapter 3. Basic Statistical Tools

Adding a secondary axis to a time series plot

Creating a time series plot

Creating a layout of graphs

Using probability plots to check the distribution of two sets of data

Finding the mean to a 95 percent confidence on interval plots

Generating a paneled boxplot

Creating a scatterplot of two variables

Creating a bar chart with a numeric response

Creating bar charts of categorical data

Creating Pareto charts

Building a table of descriptive statistics

Finding the Tally of a categorical column

Introduction

Chapter 2. Tables and Graphs

Cleaning up a text column with the calculator

Coding a numeric column to text values

Calculator – using an if statement

Calculator – basic functions

Extracting values from a date/time column

Creating a subset of data in a new worksheet

Splitting a worksheet by categorical column

Transposing the columns of a worksheet

Stacking blocks of columns at the same time

Stacking several columns together

Opening data from Access using ODBC

Opening an Excel file in Minitab

Introduction

Chapter 1. Worksheet Data Management and the Calculator

Customer support

Reader feedback

Conventions

Who this book is for

What you need for this book

What this book covers

Preface

Support files eBooks discount offers and more

www.PacktPub.com

About the Reviewers

About the Author

Credits

Minitab Cookbook

coverpage

coverpage

Minitab Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files eBooks discount offers and more

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Chapter 1. Worksheet Data Management and the Calculator

Introduction

Opening an Excel file in Minitab

Opening data from Access using ODBC

Stacking several columns together

Stacking blocks of columns at the same time

Transposing the columns of a worksheet

Splitting a worksheet by categorical column

Creating a subset of data in a new worksheet

Extracting values from a date/time column

Calculator – basic functions

Calculator – using an if statement

Coding a numeric column to text values

Cleaning up a text column with the calculator

Chapter 2. Tables and Graphs

Introduction

Finding the Tally of a categorical column

Building a table of descriptive statistics

Creating Pareto charts

Creating bar charts of categorical data

Creating a bar chart with a numeric response

Creating a scatterplot of two variables

Generating a paneled boxplot

Finding the mean to a 95 percent confidence on interval plots

Using probability plots to check the distribution of two sets of data

Creating a layout of graphs

Creating a time series plot

Adding a secondary axis to a time series plot

Chapter 3. Basic Statistical Tools

Introduction

Producing a graphical summary of data

Checking if data follows a normal distribution

Comparing the population mean to a target with a 1-Sample t-test

Using the Power and Sample Size tool for a 1-Sample t-test

Using the Assistant menu for a 1-Sample t-test

Looking for differences in the population means between two samples with a 2-Sample t-test

Using the Power and Sample Size tool for a 2-Sample t-test

Using the Assistant menu to run the 2-Sample t-test

Finding critical t-statistics using the probability distribution plot

Finding correlation between multiple variables

Using the 1 Proportion test

Graphically presenting the 1 Proportion test

Using the Power and Sample Size tool for a 1 Proportion test

Testing two population proportions with the 2 Proportions test

Using the Power and Sample Size tool for a 2 Proportions test

Using the Assistant menu to run a 2 Proportions test

Finding the sample size to estimate a mean to a given margin of error

Using Cross tabulation and Chi-Square

Using equivalence tests to prove zero difference between the mean and a target

Calculating the sample size for a 1-Sample equivalence test

Chapter 4. Using Analysis of Variance

Introduction

Using a one-way ANOVA with unstacked columns

Calculating power for the one-way ANOVA

Using Assistant to run a one-way ANOVA

Testing for equal variances

Analyzing a balanced design

Entering random effects model

Using GLM for unbalanced designs

Analyzing covariance

Analyzing a fully nested design

The repeated measures ANOVA – using a mixed effects model

Finding the critical F-statistic

Chapter 5. Regression and Modeling the Relationship between X and Y

Introduction

Visualizing simple regressions with fitted line plots

Using the Assistant tool to run a regression

Multiple regression with linear predictors

Model selection tools – the best subsets regression

Model selection tools – the stepwise regression

Binary logistic regression

Fitting a nonlinear regression

Chapter 6. Understanding Process Variation with Control Charts

Introduction

Xbar-R charts and applying stages to a control chart

Using an Xbar-S chart

Using I-MR charts

Using the Assistant tool to create control charts

Attribute charts' P (proportion) chart

Testing for overdispersion and Laney P' chart

Creating a u-chart

Testing for overdispersion and Laney U' chart

Using CUSUM charts

Finding small shifts with EWMA

Control charts for rare events – T charts

Rare event charts – G charts

Chapter 7. Capability Process Variation and Specifications

Introduction

A capability and control chart report using the capability analysis sixpack

Capability analysis for normally distributed data

Capability analysis for nonnormal distributions

Using a Box-Cox transformation for capability

Using a Johnson transformation for capability

Using the Assistant tool for short-run capability analysis

Comparing the capability of two processes using the Assistant tool

Creating an acceptance sampling plan for variable data

Creating an acceptance sampling plan for attribute data

Comparing a previously defined sampling plan – C = 0 plans

Generating run charts

Generating tolerance intervals for summarized data

Datasets that do not transform or fit any distribution

Chapter 8. Measurement Systems Analysis

Introduction

Analyzing a Type 1 Gage study

Creating a Gage R&R worksheet

Analyzing a crossed Gage R&R study

Studying a nested Gage R&R

Checking Gage linearity and bias

Expanding a Gage study with extra factors

Studying a go / no go measurement system

Using the Assistant tool for Gage R&R

Attribute Gage study from the Assistant menu

Chapter 9. Multivariate Statistics

Introduction

Finding the principal components of a set of data

Using factor analysis to identify the underlying factors

Analyzing consistency of a test paper using item analysis

Finding similarity in results by rows using cluster observations

Finding similarity across columns using cluster variables

Identifying groups in data using cluster K-means

The discriminant analysis

Analyzing two-way contingency tables with a simple correspondence analysis

Studying complex contingency tables with a multiple correspondence analysis

Chapter 10. Time Series Analysis

Introduction

Fitting a trend to data

Fitting to seasonal variation

Time series predictions without trends or seasonal variations

Chapter 11. Macro Writing

Introduction

Exec macros to repeat simple commands

Building a Global macro to create a custom graph layout

Obtaining input from the session window with a Global macro

Creating a Local macro

Local macros with subcommands submacros and control statements

Appendix A. Navigating Minitab and Useful Shortcuts

The Project Manager toolbar