title: Calculating a p-value for the spearman's rank statistic in excel (using vba or not)
body: <p>For long reasons I cannot use SPSS or another statistical package for this part of the analysis. I have two questions.</p>
  
  <p>Is there way of automatically ranking the data (from which i can later analyse). My variables go in one column (1,2,3,4,5,6....) which is already ranked by itself. My other variable can have a discrete value from 1 to 5 (e.g. 1 or 2 or 3 or 4 or 5). Even though in a way these are already ranked, it is not ranked in the way spearman wants. I think i could write some vba code to rank this myself, but if there was an automatic way it would be good to know!</p>
  
  <p>Importantly, the only reason i would want to work out the spearman correlation is that it allows me to calculate a p value which is not biased from nonnormality. However, all the guides online tell me to use a table to see if the test value is below a certain level for P&lt;.05 or whatever. How can i calculate a specific p value based on N and Rho in excel? im assuming there is a formula somewhere (I couldn't find one in my textbooks!).</p>