Thread: Spearmans Rank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LiQuIdSnAkE
 
Posts: n/a
Default 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.