Forum Discussion
Pearson matrix correlation calculation in Excel
I am trying to use correlation to calculate r values for the following data, but calculated values are "Div/0." Can anyone correct my improper setup?
| 55 | 19 | 40 | 13 | 222 | 12 | 74 | 540 |
| 19 | 40 | 13 | 222 | 12 | 74 | 540 | 55 |
| 40 | 13 | 222 | 12 | 74 | 540 | 55 | 19 |
| 13 | 222 | 12 | 74 | 540 | 55 | 19 | 40 |
| 222 | 12 | 74 | 540 | 55 | 19 | 40 | 13 |
| 12 | 74 | 540 | 55 | 19 | 40 | 13 | 222 |
| 74 | 540 | 55 | 19 | 40 | 13 | 222 | 12 |
| 540 | 55 | 19 | 40 | 13 | 222 | 12 | 74 |
Thanks,
Jon
No RepliesBe the first to reply