Book Description
With over 110 practical recipes, this is the ideal book for all statisticians who want to explore the vast capabilities of Minitab to organize data, analyze it, and visualize it with impactful graphs.
In Detail
Minitab has been a statistical package of choice across all numerous sectors of industry including education and finance. Correctly using Minitab's statistical tools is an essential part of good decision making and allows you to achieve your targeted results, while displaying fantastic charts and a powerful analysis will also communicate your results more effectively.
"Minitab Cookbook" will take the mystery out of using Minitab and will simplify the steps to produce great results. This book will be hugely beneficial for anyone who knows what statistics or studies they want to run, but who is unsure about just what button to press or what option to select.
In this book, you will learn how to use data from different sources and will be guided through the basics of graphs as well as the basics of hypothesis tests. You will explore the use of nonlinear regression, how to construct complex ANOVAs, and even delve into Multivariate statistics.
"Minitab Cookbook" is a great reference on how to create graphs, generate Pvalues, and how to put data in order. You will explore the basics of charts as well as into the complex depths of Factor analysis, and you will learn everything from the simplest of ttests to the complexity of mixed model ANOVA. And finally, for all of you who want to write Macros, this book covers the use of Execs, Global, and Local Macros.
What You Will Learn
 Import data successfully into Minitab from Excel
 Explore the options for generating amazing charts
 Investigate differences between samples with inferential statistics
 Find the significant relationships in data by analyzing variance and using regression
 Work with control charts to view process variation
 Learn about Capability Analysis in Minitab for both normal and non normal data
 Find trends and seasonality in your data
 Apply Multivariate statistics to observe patterns and relationships across many variables
 Automate tasks using the Minitab Macro language
 Use Gage studies and MSA's to investigate measurement systems
Table of Contents

Minitab Cookbook
 Table of Contents
 Minitab Cookbook
 Credits
 About the Author
 About the Reviewers
 www.PacktPub.com
 Preface

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

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

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 1Sample ttest
 Using the Power and Sample Size tool for a 1Sample ttest
 Using the Assistant menu for a 1Sample ttest
 Looking for differences in the population means between two samples with a 2Sample ttest
 Using the Power and Sample Size tool for a 2Sample ttest
 Using the Assistant menu to run the 2Sample ttest
 Finding critical tstatistics 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 ChiSquare
 Using equivalence tests to prove zero difference between the mean and a target
 Calculating the sample size for a 1Sample equivalence test

4. Using Analysis of Variance
 Introduction
 Using a oneway ANOVA with unstacked columns
 Calculating power for the oneway ANOVA
 Using Assistant to run a oneway 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 Fstatistic

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

6. Understanding Process Variation with Control Charts
 Introduction
 XbarR charts and applying stages to a control chart
 Using an XbarS chart
 Using IMR charts
 Using the Assistant tool to create control charts
 Attribute charts' P (proportion) chart
 Testing for overdispersion and Laney P' chart
 Creating a uchart
 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

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 BoxCox transformation for capability
 Using a Johnson transformation for capability
 Using the Assistant tool for shortrun 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

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

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 Kmeans
 The discriminant analysis
 Analyzing twoway contingency tables with a simple correspondence analysis
 Studying complex contingency tables with a multiple correspondence analysis
 10. Time Series Analysis
 11. Macro Writing
 A. Navigating Minitab and Useful Shortcuts
 Index
Product Information
 Title: Minitab Cookbook
 Author(s):
 Release date: February 2014
 Publisher(s): Packt Publishing
 ISBN: 9781782170921