Thanks for the feedback Ogunwusi. So I performed a two-tailed analysis because I did not pre-specify a certain direction in my hypothesis. If my null hypothesis was 'There is no POSITIVE association between variable X and variable Y', then I would perform a one-tailed analysis because I am stating a positive association (as apposed to any [positive or negative] association). I'll create a tutorial on the differences between one-and two-tailed analyses in the future. Hope that helps. Steven
I also believe that correl does not provide a Spearman rho. One should use the Spearman formula of rho = 1- (6*sum d^2)/(n^3-n). Correl gives a different outcome since it calculates Pearson.
@@1997alimaster yes but since the data is ranked its measuring the correlation between the ranks, not the data itself. For my set of data I get the same answer doing it with the formula and on excel.
I've got a problem, my rs is a perfect 1 or a perfect -1, and my number of sampling units is 3. That results in a division by 0 when calculating the t-statistic. Can I do anything to get a number for my t-stats?
@@StevenBradburn I did use sampling units with sample sizes of greater than 100 observations. These sampling units are transects of surveys conducted at individual sites, so I did 3 transects per site and the I am looking at relationship between adult and juvenile trees across these transects. If I get a perfect score, of 1 or -1, then I get a division by 0. Is that a bad idea?
Is your correlation coefficient value a negative value? If so, be sure to include the ABS function in the T statistic formula as shown in the video 05:18
@@StevenBradburn I also put in the ABS and still got #num!. I even decided to try to multiply my coefficient by -1 to make it positive and it still didn’t work.
THE ONLINE GUIDE
toptipbio.com/spearman-correlation-excel/
This is incredibly helpful. Everything is explained really clearly so I actually understand the reason behind each step. Thank you!
Excellent! So glad it was helpful for you :)
I am doing a university project and this video saved me, thank you! It was very useful and easy to understand!
Excellent. Thanks for the feedback. Good luck with your project
Never left a comment before, but thank you very much. Our teacher was trying to make us to do this manually in Excell
thank you so much this really helped me with my last Psych statistics assignment and you explained it very well.
Wow thank you for this! Helps a lot in my online assessments
This is SOOOOO helpful! Thank you so much for posting.
Very welcome Cassie
Great! Its important to remember that one does this when data is ordinal
Thank you for this, very helpful. Still not clear on 1 or 2 tailed test but that seems to be a tough one.
Can't thank you enough for this amazing video....made it so easy to use the test..thank you 🤗
Great tutorial! This tutorial helped me alot. Thank you!
Thank you for explaining how to interpret the results, not just do them. this helped so much.
Really helpful! Thank you!
Very well explained, thank you
Thank you so much. You are heaven sent!
Ok this is another great way of remembering this procedure when the data is ordinal
Thank you a lot, it was super useful! your way to explain is awesome
Thanks :)
Thank you, very helpful
This is a great video with excellent explanation. Please I would like to know why you performed a two tailed test on the dataset. Thank you
Thanks for the feedback Ogunwusi. So I performed a two-tailed analysis because I did not pre-specify a certain direction in my hypothesis. If my null hypothesis was 'There is no POSITIVE association between variable X and variable Y', then I would perform a one-tailed analysis because I am stating a positive association (as apposed to any [positive or negative] association). I'll create a tutorial on the differences between one-and two-tailed analyses in the future. Hope that helps. Steven
Fantastic video!
Thanks for saving me!🙏💕
Can i use this for likert scale values ?
Omg Thank You so so much. It literally helped me pass.😭🌻🌞❤
Very welcome Shravani!
THANK YOU SO MUCH!
don´t you need to put the ranking in order before?
In the rank correlation if there is any repeated values then the m(m^2-1)/12 formula is used ...? so how it is calculated in excel?
You can lock column and row together by simply clicking F4.
Very good!
hi, may I know if there is a paper that I can cite for the formula for t-statistic?
hi, may i ask how to rank three same data? :((
saved my life!!
Thank you so much
Can this be used for two likert scale data?
very helpful!
Thank you sir
You saved me
Does it have to be a 2 tailed test every time? Or choosing 1 or 2 tailed test does not really matter that much?
Is there a way to do this faster, I have a lot more values
Thank You
thanks man
What does the t-statistic and p-value mean?
shouldn't the ranking be descending for spearman's correlation?
THANK YOU.
Especially for the explanation.
So the CORREL function in Excel is really only a Pearson correlation coefficient, i.e. not possible to apply on two variables with raw ordinal data?
I also believe that correl does not provide a Spearman rho. One should use the Spearman formula of rho = 1- (6*sum d^2)/(n^3-n). Correl gives a different outcome since it calculates Pearson.
@@1997alimaster yes but since the data is ranked its measuring the correlation between the ranks, not the data itself. For my set of data I get the same answer doing it with the formula and on excel.
I've got a problem, my rs is a perfect 1 or a perfect -1, and my number of sampling units is 3. That results in a division by 0 when calculating the t-statistic. Can I do anything to get a number for my t-stats?
Hi Sebastian. I would not advise to perform correlation analysis with only 3 samples
@@StevenBradburn I did use sampling units with sample sizes of greater than 100 observations. These sampling units are transects of surveys conducted at individual sites, so I did 3 transects per site and the I am looking at relationship between adult and juvenile trees across these transects. If I get a perfect score, of 1 or -1, then I get a division by 0. Is that a bad idea?
how is the degrees of freedom formula not: (n-1)
It's based on how many variables you have, since he has two it's n-2
it just says #value! in the cell?
My p value is coming 3.4584E-19. How can I interpret it
it is very less than .05, so there is significant (positive or negative depends on the sign of your *r* value) correlation between the two arrays.
I use to suffer from statistics
my coefficiant is -1 and bcus of this i cant find my t statistic why?
you should take abs value
HI! WHY DOES IT SHOW WRONG FORMULA FOR ME?
Hi, have you solved it?
My is showing #name?
i love u
My T statistic is showing #num!
Is your correlation coefficient value a negative value? If so, be sure to include the ABS function in the T statistic formula as shown in the video 05:18
@@StevenBradburn hi why is it even if I have included the ABS function, it still shows #num! ?
@@StevenBradburn I also put in the ABS and still got #num!. I even decided to try to multiply my coefficient by -1 to make it positive and it still didn’t work.