Minitab Cookbook电子书

Minitab Cookbook

Table of Contents

Minitab Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Downloading the color images of this book

Errata

Piracy

Copyright

Questions

1. Worksheet, Data Management, and the Calculator

Introduction

Opening an Excel file in Minitab

Getting ready

How to do it…

How it works…

There's more…

See also

Opening data from Access using ODBC

Getting ready

How to do it…

How it works…

Stacking several columns together

Getting ready

How to do it…

How it works…

See also

Stacking blocks of columns at the same time

Getting ready

How to do it…

How it works…

See also

Transposing the columns of a worksheet

Getting ready

How to do it…

How it works…

See also

Splitting a worksheet by categorical column

Getting ready

How to do it…

How it works…

See also

Creating a subset of data in a new worksheet

Getting ready

How to do it...

How it works…

There's more…

See also

Extracting values from a date/time column

Getting ready

How to do it…

How it works…

Calculator – basic functions

Getting ready

How to do it…

How it works…

There's more…

See also

Calculator – using an if statement

Getting ready

How to do it…

How it works…

There's more…

See also

Coding a numeric column to text values

Getting ready

How to do it…

How it works…

There's more…

See also

Cleaning up a text column with the calculator

Getting ready

How to do it…

How it works…

There's more…

2. Tables and Graphs

Introduction

Finding the Tally of a categorical column

How to do it…

How it works…

See also

Building a table of descriptive statistics

How to do it…

How it works…

See also

Creating Pareto charts

How to do it…

How it works…

There's more…

See also

Creating bar charts of categorical data

How to do it…

How it works…

There's more…

See also

Creating a bar chart with a numeric response

How to do it…

How it works…

There's more…

See also

Creating a scatterplot of two variables

How to do it…

How it works…

There's more…

See also

Generating a paneled boxplot

Getting ready

How to do it…

How it works…

There's more…

See also

Finding the mean to a 95 percent confidence on interval plots

How to do it…

How it works…

See also

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

How to do it…

How it works…

There's more

Creating a layout of graphs

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a time series plot

Getting ready

How to do it…

How it works…

There's more…

See also

Adding a secondary axis to a time series plot

Getting ready

How to do it…

How it works…

3. Basic Statistical Tools

Introduction

Producing a graphical summary of data

Getting ready

How to do it…

How it works…

There's more…

See also

Checking if data follows a normal distribution

Getting ready

How to do it…

How it works…

See also

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

Getting ready

How to do it…

How it works…

There's more…

See also

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

Getting ready

How to do it…

How it works…

See also

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

Getting ready

How to do it…

How it works…

See also

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

Getting ready

How to do it…

How it works…

There's more…

See also

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

How to do it…

How it works…

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

How to do it…

How it works…

See also

Finding critical t-statistics using the probability distribution plot

How to do it…

How it works…

There's more…

Finding correlation between multiple variables

Getting ready

How to do it…

How it works…

There's more…

See also

Using the 1 Proportion test

Getting ready

How to do it…

How it works…

See also

Graphically presenting the 1 Proportion test

Getting ready

How to do it…

How it works…

See also

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

How to do it…

How it works…

See also

Testing two population proportions with the 2 Proportions test

Getting ready

How to do it…

How it works…

See also

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

Getting ready

How to do it…

How it works…

See also

Using the Assistant menu to run a 2 Proportions test

How to do it…

How it works…

See also

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

How to do it…

How it works…

See also

Using Cross tabulation and Chi-Square

Getting ready

How to do it…

How it works…

There's more…

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

Getting ready

How to do it…

How it works…

There's more…

See also

Calculating the sample size for a 1-Sample equivalence test

Getting Ready

How to do it…

How it works…

See also

4. Using Analysis of Variance

Introduction

Using a one-way ANOVA with unstacked columns

Getting ready

How to do it…

How it works…

See also

Calculating power for the one-way ANOVA

How to do it…

How it works…

See also

Using Assistant to run a one-way ANOVA

How to do it…

How it works…

See also

Testing for equal variances

Getting ready

How to do it…

How it works…

There's more…

See also

Analyzing a balanced design

Getting ready

How to do it…

How it works…

See also

Entering random effects model

Getting ready

How to do it…

How it works…

There's more…

See also

Using GLM for unbalanced designs

Getting ready

How to do it…

How it works…

There's more…

See also

Analyzing covariance

Getting ready

How to do it…

How it works…

There's more…

See also

Analyzing a fully nested design

Getting ready

How to do it…

How it works…

The repeated measures ANOVA – using a mixed effects model

Getting ready

How to do it…

How it works…

Finding the critical F-statistic

How to do it…

How it works…

See also

5. Regression and Modeling the Relationship between X and Y

Introduction

Visualizing simple regressions with fitted line plots

Getting ready

How to do it…

How it works…

There's more…

See also

Using the Assistant tool to run a regression

Getting ready

How to do it…

How it works…

There's more…

See also

Multiple regression with linear predictors

Getting ready

How to do it…

How it works…

There's more…

See also

Model selection tools – the best subsets regression

Getting ready

How to do it…

How it works…

See also

Model selection tools – the stepwise regression

Getting ready

How to do it…

How it works…

See also

Binary logistic regression

Getting ready

How to do it…

How it works…

See also

Fitting a nonlinear regression

Getting ready

How to do it…

How it works…

There's More…

See also

6. Understanding Process Variation with Control Charts

Introduction

Xbar-R charts and applying stages to a control chart

How to do it…

How it works…

There's more…

See also

Using an Xbar-S chart

How to do it…

How it works…

There's more…

See also

Using I-MR charts

Getting ready

How to do it...

How it works…

There's more…

See also

Using the Assistant tool to create control charts

How to do it...

How it works…

See also

Attribute charts' P (proportion) chart

Getting ready

How to do it...

How it works…

There's more…

See also

Testing for overdispersion and Laney P' chart

How to do it...

How it works…

There's more…

See also

Creating a u-chart

Getting ready

How to do it...

How it works…

See also

Testing for overdispersion and Laney U' chart

How to do it...

How it works…

See also

Using CUSUM charts

How to do it...

How it works…

See also

Finding small shifts with EWMA

Getting ready

How to do it...

How it works…

See also

Control charts for rare events – T charts

How to do it...

How it works…

There's more…

See also

Rare event charts – G charts

How to do it...

How it works…

See also

7. Capability, Process Variation, and Specifications

Introduction

A capability and control chart report using the capability analysis sixpack

How to do it...

How it works…

There's more…

See also

Capability analysis for normally distributed data

How to do it...

How it works…

There's more…

See also

Capability analysis for nonnormal distributions

How to do it...

How it works…

There's more…

See also

Using a Box-Cox transformation for capability

How to do it...

How it works…

There's more…

See also

Using a Johnson transformation for capability

How to do it...

How it works…

See also

Using the Assistant tool for short-run capability analysis

How to do it...

How it works…

There's more…

See also

Comparing the capability of two processes using the Assistant tool

How to do it...

How it works…

There's more…

See also

Creating an acceptance sampling plan for variable data

How to do it...

How it works…

There's more…

See also

Creating an acceptance sampling plan for attribute data

Getting ready

How to do it...

How it works…

There's more…

See also

Comparing a previously defined sampling plan – C = 0 plans

Getting ready

How to do it...

How it works…

There's more…

See also

Generating run charts

How to do it...

How it works…

There's more…

See also

Generating tolerance intervals for summarized data

How to do it...

How it works…

See also

Datasets that do not transform or fit any distribution

How to do it...

How it works…

There's more…

See also

8. Measurement Systems Analysis

Introduction

Analyzing a Type 1 Gage study

How to do it…

How it works…

There's more…

See also

Creating a Gage R&R worksheet

How to do it…

How it works…

There's more…

See also

Analyzing a crossed Gage R&R study

How to do it…

How it works…

There's more…

See also

Studying a nested Gage R&R

How to do it…

How it works…

There's more…

See also

Checking Gage linearity and bias

How to do it…

How it works…

There's more…

See also

Expanding a Gage study with extra factors

How to do it…

How it works…

There's more…

See also

Studying a go / no go measurement system

Getting ready

How to do it…

How it works…

Using the Assistant tool for Gage R&R

How to do it…

How it works…

There's more…

See also

Attribute Gage study from the Assistant menu

How to do it…

How it works…

There's more…

9. Multivariate Statistics

Introduction

Finding the principal components of a set of data

How to do it…

How it works…

There's more…

See also

Using factor analysis to identify the underlying factors

How to do it…

How it works…

See also

Analyzing consistency of a test paper using item analysis

How to do it…

How it works…

There's more…

See also

Finding similarity in results by rows using cluster observations

How to do it…

How it works…

There's more…

See also

Finding similarity across columns using cluster variables

How to do it…

How it works…

See also

Identifying groups in data using cluster K-means

How to do it…

How it works…

There's more…

See also

The discriminant analysis

Getting ready

How to do it…

How it works…

There's more…

Analyzing two-way contingency tables with a simple correspondence analysis

Getting ready

How to do it…

How it works…

There's more…

See also

Studying complex contingency tables with a multiple correspondence analysis

How to do it…

How it works…

There's more…

See also

10. Time Series Analysis

Introduction

Fitting a trend to data

How to do it…

How it works…

There's more…

See also

Fitting to seasonal variation

How to do it…

How it works…

There's more…

See also

Time series predictions without trends or seasonal variations

How to do it…

How it works…

See also

11. Macro Writing

Introduction

Useful information for writing macros

Preparing to run macros

Debugging

Exec macros to repeat simple commands

Getting ready

How to do it…

How it works…

There's more…

See also

Building a Global macro to create a custom graph layout

Getting ready

How to do it…

How it works…

There's more…

See also

Obtaining input from the session window with a Global macro

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a Local macro

Getting ready

How to do it…

How it works…

There's more…

See also

Local macros with subcommands, submacros, and control statements

Getting ready

How to do it…

How it works…

There's more…

A. Navigating Minitab and Useful Shortcuts

The Project Manager toolbar

Show Session Folder

Show Worksheets Folder

Show Graphs Folder

Show Info

Show History

Show ReportPad

Changing default settings in Minitab

Useful keyboard shortcuts

Links to data, and sites used in the book

Index