Plz this formula!!! Thx

  • Thread starter Thread starter KrisB_bacon
  • Start date Start date
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
 
Kris

"ISNUMBER(E14)" simply checks to see if there is a number in cell C14.
It returns TRUE or FALSE.
If it is TRUE it evaluates the formula between the next set of commas.
,((RANK(E14,E$13:E$1012,1)+COUNT(E$13:E$1012)-RANK(E14,E$13:E$1012,0)+1)/2),
If it is False it returns whatever is between the next set of commas.
"-"

If you put the cursor on the function in the formula bar and then click on
"fx" (office XP) or "=" (other versions) it will explain what the function
does.

Alan
 
Back
Top