software

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.

LiQuIdSnAkE -

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

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

- Mike
www.mikemiddleton.com

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