Spearmans Rank
 

Is there a easy way in Excel to find a correlation between two sets of data
using Spearmans Rank? (GSCE maths coursework) or even just an easy way of
ranking the data. Using the Rs = 1-(6Sigma d2/n3-n) formula is easy to do by
hand.

Spearmans Rank
 

LiQuIdSnAkE -

If you go to Google and search for "Excel Spearmans Rank," the first result
is

http://www.mrexcel.com/archive2/39600/45884.htm

- Mike
www.mikemiddleton.com

"LiQuIdSnAkE" wrote in message
...
Is there a easy way in Excel to find a correlation between two sets of
data
using Spearmans Rank? (GSCE maths coursework) or even just an easy way of
ranking the data. Using the Rs = 1-(6Sigma d2/n3-n) formula is easy to do
by
hand.