## 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 non-linear regression, how to construct complex ANOVAs, and even delve into Multivariate statistics.

"Minitab Cookbook" is a great reference on how to create graphs, generate P-values, 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 t-tests 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

1. Minitab Cookbook
2. Minitab Cookbook
3. Credits
6. www.PacktPub.com
1. Support files, eBooks, discount offers and more
7. Preface
1. What this book covers
2. What you need for this book
3. Who this book is for
4. Conventions
6. Customer support
8. 1. Worksheet, Data Management, and the Calculator
1. Introduction
2. Opening an Excel file in Minitab
3. Opening data from Access using ODBC
4. Stacking several columns together
5. Stacking blocks of columns at the same time
6. Transposing the columns of a worksheet
7. Splitting a worksheet by categorical column
8. Creating a subset of data in a new worksheet
9. Extracting values from a date/time column
10. Calculator – basic functions
11. Calculator – using an if statement
12. Coding a numeric column to text values
13. Cleaning up a text column with the calculator
9. 2. Tables and Graphs
1. Introduction
2. Finding the Tally of a categorical column
3. Building a table of descriptive statistics
4. Creating Pareto charts
5. Creating bar charts of categorical data
6. Creating a bar chart with a numeric response
7. Creating a scatterplot of two variables
8. Generating a paneled boxplot
9. Finding the mean to a 95 percent confidence on interval plots
10. Using probability plots to check the distribution of two sets of data
11. Creating a layout of graphs
12. Creating a time series plot
13. Adding a secondary axis to a time series plot
10. 3. Basic Statistical Tools
1. Introduction
2. Producing a graphical summary of data
3. Checking if data follows a normal distribution
4. Comparing the population mean to a target with a 1-Sample t-test
5. Using the Power and Sample Size tool for a 1-Sample t-test
6. Using the Assistant menu for a 1-Sample t-test
7. Looking for differences in the population means between two samples with a 2-Sample t-test
8. Using the Power and Sample Size tool for a 2-Sample t-test
9. Using the Assistant menu to run the 2-Sample t-test
10. Finding critical t-statistics using the probability distribution plot
11. Finding correlation between multiple variables
12. Using the 1 Proportion test
13. Graphically presenting the 1 Proportion test
14. Using the Power and Sample Size tool for a 1 Proportion test
15. Testing two population proportions with the 2 Proportions test
16. Using the Power and Sample Size tool for a 2 Proportions test
17. Using the Assistant menu to run a 2 Proportions test
18. Finding the sample size to estimate a mean to a given margin of error
19. Using Cross tabulation and Chi-Square
20. Using equivalence tests to prove zero difference between the mean and a target
21. Calculating the sample size for a 1-Sample equivalence test
11. 4. Using Analysis of Variance
1. Introduction
2. Using a one-way ANOVA with unstacked columns
3. Calculating power for the one-way ANOVA
4. Using Assistant to run a one-way ANOVA
5. Testing for equal variances
6. Analyzing a balanced design
7. Entering random effects model
8. Using GLM for unbalanced designs
9. Analyzing covariance
10. Analyzing a fully nested design
11. The repeated measures ANOVA – using a mixed effects model
12. Finding the critical F-statistic
12. 5. Regression and Modeling the Relationship between X and Y
1. Introduction
2. Visualizing simple regressions with fitted line plots
3. Using the Assistant tool to run a regression
4. Multiple regression with linear predictors
5. Model selection tools – the best subsets regression
6. Model selection tools – the stepwise regression
7. Binary logistic regression
8. Fitting a nonlinear regression
13. 6. Understanding Process Variation with Control Charts
1. Introduction
2. Xbar-R charts and applying stages to a control chart
3. Using an Xbar-S chart
4. Using I-MR charts
5. Using the Assistant tool to create control charts
6. Attribute charts' P (proportion) chart
7. Testing for overdispersion and Laney P' chart
8. Creating a u-chart
9. Testing for overdispersion and Laney U' chart
10. Using CUSUM charts
11. Finding small shifts with EWMA
12. Control charts for rare events – T charts
13. Rare event charts – G charts
14. 7. Capability, Process Variation, and Specifications
1. Introduction
2. A capability and control chart report using the capability analysis sixpack
3. Capability analysis for normally distributed data
4. Capability analysis for nonnormal distributions
5. Using a Box-Cox transformation for capability
6. Using a Johnson transformation for capability
7. Using the Assistant tool for short-run capability analysis
8. Comparing the capability of two processes using the Assistant tool
9. Creating an acceptance sampling plan for variable data
10. Creating an acceptance sampling plan for attribute data
11. Comparing a previously defined sampling plan – C = 0 plans
12. Generating run charts
13. Generating tolerance intervals for summarized data
14. Datasets that do not transform or fit any distribution
15. 8. Measurement Systems Analysis
1. Introduction
2. Analyzing a Type 1 Gage study
3. Creating a Gage R&R worksheet
4. Analyzing a crossed Gage R&R study
5. Studying a nested Gage R&R
6. Checking Gage linearity and bias
7. Expanding a Gage study with extra factors
8. Studying a go / no go measurement system
9. Using the Assistant tool for Gage R&R
10. Attribute Gage study from the Assistant menu
16. 9. Multivariate Statistics
1. Introduction
2. Finding the principal components of a set of data
3. Using factor analysis to identify the underlying factors
4. Analyzing consistency of a test paper using item analysis
5. Finding similarity in results by rows using cluster observations
6. Finding similarity across columns using cluster variables
7. Identifying groups in data using cluster K-means
8. The discriminant analysis
9. Analyzing two-way contingency tables with a simple correspondence analysis
10. Studying complex contingency tables with a multiple correspondence analysis
17. 10. Time Series Analysis
1. Introduction
2. Fitting a trend to data
3. Fitting to seasonal variation
4. Time series predictions without trends or seasonal variations
18. 11. Macro Writing
1. Introduction
2. Exec macros to repeat simple commands
3. Building a Global macro to create a custom graph layout
4. Obtaining input from the session window with a Global macro
5. Creating a Local macro
6. Local macros with subcommands, submacros, and control statements
19. A. Navigating Minitab and Useful Shortcuts
1. The Project Manager toolbar
20. Index

## Product Information

• Title: Minitab Cookbook
• Author(s): Isaac Newton
• Release date: February 2014
• Publisher(s): Packt Publishing
• ISBN: 9781782170921