Forum Discussion

Kumar11109's avatar
Kumar11109
Helper IV
8 years ago
Solved

Correlation Between Two Columns

Dear All,    I am trying to find a correlation between the number of attempts and the score obtained with each attempt. I have attached a screenshot for a sample of data.  How can I do this using p...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Kumar11109,

What Greg_Deckler posted is right, please right click the column->quick measure->Correlation coefficient as follows.



Best Regards,
Angelia

  • Kumar11109's avatar
    Kumar11109
    Helper IV
    8 years ago

    I want to find a correlation with each attempt what are the scores, I don't want to aggregate either of the variables. This correlation option aggregates the values.  Is there any other way?