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.

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

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.

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.

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!