## How to calculate the spearman correlation in excel?

Asked By 20 points N/A Posted on -

Hi, can anyone tell me whether I can calculate spearman correlation in excel? If yes, then please let me know how to calculate.

SHARE
Answered By 0 points N/A #328720

## How to calculate the spearman correlation in excel?

There is no direct way of calculating spearman correlation in excel. But there is a process using which you can easily do that. Follow the steps –

Consider the above data.

1 – Type “=RANK.AVG(B2,\$B\$2:\$B\$11,0)” in D2 and drag it up to D11 to rank the                      physical activity variable.

2 – Type “=RANK.AVG(C2,\$C\$2:\$C\$11,0)” in E2 and drag it up to E11 to rank the                      blood pressure variable.