Statistics How To

Minitab Correlation Coefficient: How to Calculate it

Correlation coefficient > Minitab Correlation Coefficient

How to Calculate the Minitab Correlation Coefficient

Watch this video on how to calculate the correlation coefficient in Minitab, or read the steps in the article below:

The Minitab correlation coefficient will return a value for r from -1 to 1.

Sample question: Find the Minitab correlation coefficient based on age vs. glucose level from the following table from a pre-diabetic study of 6 participants:

Subject Age x Glucose Level y
1 43 99
2 21 65
3 25 79
4 42 75
5 57 87
6 59 81

Step 1: Type your data into a Minitab worksheet. I entered this sample data into three columns.

minitab correlation coefficient

Data entered into three columns in a Minitab worksheet.

Step 2: Click “Stat”, then click “Basic Statistics” and then click “Correlation.”

"Correlation" is selected from the "Stats>Basic Statistics" menu.

“Correlation” is selected from the “Stats>Basic Statistics” menu.

Step 3: Click a variable name in the left window and then click the “Select” button to move the variable name to the Variable box. For this sample question, click “Age,” then click “Select,” then click “Glucose Level” then click “Select” to transfer both variables to the Variable window.
pearson in minitab 3

Step 4: (Optional) Check the “P-Value” box if you want to display a P-Value for r.

Step 5: Click “OK”. The Minitab correlation coefficient will be displayed in the Session Window. If you don’t see the results, click “Window” and then click “Tile.” The Session window should appear.

Results from the Minitab correlation.

Results from the Minitab correlation.

For this dataset:
Value of r: 0.530
P-Value: 0.280
That’s it!

Tip: Give your columns meaningful names (in the first row of the column, right under C1, C2 etc.). That way, when it comes to choosing variable names in Step 3, you’ll easily see what it is you are trying to choose. This becomes especially important when you have dozens of columns of variables in a data sheet!

If you prefer an online interactive environment to learn R and statistics, this free R Tutorial by Datacamp is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try this Statistics with R track.

Comments are now closed for this post. Need help or want to post a correction? Please post a comment on our Facebook page and I'll do my best to help!
Minitab Correlation Coefficient: How to Calculate it was last modified: October 12th, 2017 by Andale