K
KrisB_bacon
I'm trying to set up a worksheet that helps students calculate Spearmans
rank from sets of readings (statistical tool to find if there is a
correlation. I could not produce it myself so I went looking on the
internet and found this site.
http://udel.edu/~mcdonald/statspearman.html
Here, after clicking on the link to a windows excel spreadsheet, a
spearmans rank worksheet that had the formula I wanted. However, being
a less than advanced user of Excel I do not understand all of it:
=IF(ISNUMBER(E14),((RANK(E14,E$13:E$1012,1)+COUNT(E$13:E$1012)-RANK(E14,E$13:E$1012,0)+1)/2),"-")
I have a basic understanding of IF, COUNT AND RANK functions but not of
the ISNUMBER. I also understand the $ and quotations.
It would be a huge help if someone could explain the formula to me,
especially the ISNUMBER and what (the bit at the end) is divided by 2
or having 1 added to it.
Explaining this would be a HUGE help to me and would increase my
knowledge of excel.
Thx for anyone who replies
rank from sets of readings (statistical tool to find if there is a
correlation. I could not produce it myself so I went looking on the
internet and found this site.
http://udel.edu/~mcdonald/statspearman.html
Here, after clicking on the link to a windows excel spreadsheet, a
spearmans rank worksheet that had the formula I wanted. However, being
a less than advanced user of Excel I do not understand all of it:
=IF(ISNUMBER(E14),((RANK(E14,E$13:E$1012,1)+COUNT(E$13:E$1012)-RANK(E14,E$13:E$1012,0)+1)/2),"-")
I have a basic understanding of IF, COUNT AND RANK functions but not of
the ISNUMBER. I also understand the $ and quotations.
It would be a huge help if someone could explain the formula to me,
especially the ISNUMBER and what (the bit at the end) is divided by 2
or having 1 added to it.
Explaining this would be a HUGE help to me and would increase my
knowledge of excel.
Thx for anyone who replies