Correlation coefficient
The quick measure calculates the Pearson correlation coefficient between two measures within the category.
NAME:
Correlation coefficient
DESCRIPTION:
Calculate the Pearson correlation...
Discard the Index column? I assumed that would be the 'Category' element of the quick measure. Would it be correct to instead have the following, where the elements of the quick measure are:
Category = Day of Week column
Measure X = Day of Week Key column
Measure Y = Temp column
| Index | Day of Week | Day of Week Key | Temp |
| 1 | Monday | 1 | 20 |
| 2 | Monday | 1 | 24 |
| 3 | Monday | 1 | 19 |
| 4 | Wednesday | 2 | 15 |
| 5 | Wednesday | 2 | 28 |
| 6 | Wednesday | 2 | 12 |
| 7 | Wednesday | 2 | 20 |
| 8 | Friday | 3 | 20 |
| 9 | Friday | 3 | 10 |
Ah, the quick measure. I never understood why they added a category there and made it mandatory. It has (in my opinion) nothing to do with the computation. I always implement the Pearson algorithm manually.