Correlation coefficient
The quick measure calculates the Pearson correlation coefficient between two measures within the category.
NAME:
Correlation coefficient
DESCRIPTION:
Calculate the Pearson correlation...
yes, that's what I am saying. Replace text values with their numerical index and compute the correlation over the indexes. Afterwards you can map it back.
(bit unfortunate that your sample table has an "Index" column. Please discard that, it doesn't help)
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.