You are previewing Minitab Cookbook.
O'Reilly logo
Minitab Cookbook

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
  • Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

    Table of Contents

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