The following example will be used to demonstrate the procedure to calculate a correlation coefficient by-hand, using MS Excel, and using Minitab.
Example: Assume that during a three-hour period spent outside, a person
recorded the temperature and their water
consumption. The experiment was
conducted on 7 randomly selected days during the summer. The data is shown
in the table below.
Find the
correlation
between the temperature and the amount of water
consumed.
| Day | Temperature (F) | Water Consumption (oz) |
| 1 | 99 |
48 |
| 2 | 85 | 27 |
| 3 | 97 | 48 |
| 4 | 75 | 16 |
| 5 | 92 | 32 |
| 6 | 85 | 25 |
| 7 | 83 | 20 |
Learn the Procedure for calculating Pearson's Correlation
Coefficient
