Statistics How To

Minitab Correlation Coefficient: How to Calculate it

Return to the main Minitab index > 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!

Minitab Correlation Coefficient: How to Calculate it was last modified: November 29th, 2015 by Andale

Leave a Reply

Your email address will not be published. Required fields are marked *