Spearmans Rank

[LiQuIdSnAkE]

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.

 

[Mike Middleton]

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