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 – basic functions

The e-calculator tool is analogous to formulas in Excel. In Minitab, we will run calculations on the columns one at a time. Using the weather data from the Oxford station, we will create a new column for the hours of sunlight in a month divided bythe amount of rainfall (in millimeters) for that month.

Getting ready

We will be using data from Oxford weather station; it can be obtained from http://www.metoffice.gov.uk/climate/uk/stationdata/. Select Oxford weather station data and copy the data into Minitab. Only copy the data and not the column headers. Then, rename the columns as Year, Month, T Max, T Min, Airfrost(days), Rain(mm), and Sun(Hrs).

Note

Inspect the data that we copy to ensure that the columns have the right data type. The column header C1-T will indicate text, C1-D will indicate data, and C1 without the hyphen is a numeric column.

Also, note that a few of the values in the data will be recorded as missing; this is where text values are supplied next to the number. A cleaned worksheet is provided in the Oxford weather (cleaned).mtw file.

How to do it…

The following instructions will create a new column for the hours of sunlight to amount of rainfall in a month ratio:

  1. Go to the Calc menu and click on Calculator.

  2. In the dialog box, enter a name for the new column into the Store result in Variable section. We will name it as 'Sun(Hrs)/Rain(mm)'.

  3. Select the section labeled Expression, and then double-click on Sun (Hours) to move it across, enter /, and then move the Rain(mm) column over.

  4. Tick the box labeled Assign as formula and click on OK.

How it works…

The results of this function are generated in the selected column. The checkbox Assign as a formula will create a formula in the worksheet that will keep updating it. By default, this is not selected to avoid problems with circular or self-referencing formulas. When a formula is stored in a column, a green cross is placed at the top of the column to indicate the presence of a formula. The green cross indicates that this is up-to-date, while a red cross would indicate a problem in updating the formula.

There's more…

The calculator in Minitab has a plethora of functions available. We can choose from the function list on the right in the calculator screen. These include several statistical, mathematical, and text functions. They can be filtered with the drop-down list at the top. The help function for the calculator includes a list of functions and how to use them.

See also

  • The Calculator – using an if statement recipe

  • The Cleaning up a text column with the calculator 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