Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Minitab Cookbook
  • Table Of Contents Toc
Minitab Cookbook

Minitab Cookbook

By : Isaac A Newton
4.4 (8)
Buy this Book
close
close
Minitab Cookbook

Minitab Cookbook

4.4 (8)
By: Isaac A Newton
Buy this Book

Overview of this book

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

Calculator – using an if statement

If statements can be useful tools in extracting information from a column or in reformatting data. Here, we will recode the values in the pulse worksheet.

In the pulse dataset, the C4 smokes column indicates if an individual is a smoker. 1 indicates a regular smoker and 2 stands for those who do not smoke. We will use an if statement to replace the numeric values for smokers and nonsmokers.

Getting ready

The data used here is one of the example files that come with Minitab. Open the pulse.mtw worksheet from the sample Minitab data folder by going to the File menu and clicking on Open Worksheet. Select the icon Look in Minitab Sample Data folder.

How to do it…

The following instructions will convert the values of 1 and 2 in the Smokes column to Smokes and Non-Smoker

  1. Go to the Calc menu and select Calculator.

  2. In Store result in variable, enter the column Smokes.

  3. In the Expression text box, enter IF('Smokes' = 1, "Smoker", "Non-Smoker").

  4. Click on OK.

How it works…

An if statement is entered in the following format: IF(Logical statement, TRUE, FALSE); the value entered after the first comma being the true for the statement. Numeric values for the response are entered purely as numbers without any double quotes. Text is always entered inside double quotes, for example, "True". Column names are used with single quotes, for example, 'Pulse1'.

Note

Column names can be typed, double-clicked, or selected in the column from the available list on the left of the dialog box. While single quotes are used to denote columns, they are not always necessary. A column name, that is, a single name without special characters or spaces in the name does not need to be referred to with single quotes. The column Ran can be used as Ran or 'Ran'. Selecting a column from the list will automatically enter single quotes where necessary.

There's more…

The IF statements can be generalized to multiple IF conditions very simply. A general IF statement would have the following syntax:

IF(Statement1, True1, Statement2, True2… StatementN, TrueN, False)

When identifying missing values in the worksheet, the code must be used as the first statement. These values can be identified with the code Miss() or '*'.

For example, the following will identify a missing result in the Smokes column as Unknown, 1 as Smoker, and all others as Non-Smoker:

IF('Smokes' = '*', "Unknown", 'Smokes' = 1, "Smoker", "Non-Smoker")

See also

  • The Calculator – basic functions recipe

  • The Coding a numeric column to text values recipe

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Minitab Cookbook
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon