For long reasons I cannot use SPSS or another statistical package for this part of the analysis. I have two questions.
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!
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<.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!).