s has a t-distribution with df=n-2
I have a spearman result set, that was calculated from 11,012 observations, with spearman=.581, and I'm looking to find the critical value (a=.05). I have found the formula, s= r* sqrt(n-2)/sqrt(1-power(r,2)) but this seems to give me a value of 74.903 How do I calculate this critical value?
Thank you. I'm still new at this as I'm learning out of a book. How did you get .28063 and 1.645 and what do they represent? Can this be shown in Excel or is it done using a lookup?