Це відео не доступне.
Перепрошуємо.
Perform A Spearman's Rank Correlation Test In Excel
Вставка
- Опубліковано 17 сер 2024
- In this tutorial, I will show you how to perform a Spearman's rank correlation test in Microsoft Excel. Firstly I will show you how to calculate the Spearman's rank correlation coefficient. Then I will show you how to calculate a p value from this coefficient value.
THE ONLINE GUIDE
toptipbio.com/...
PEARSON CORRELATION IN EXCEL
• How To Perform A Pears...
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Laptop amzn.to/38bB7JG
Microphone amzn.to/2OFn1sd
Screen recorder & editor techsmith.z6rj...
UA-cam SEO www.tubebuddy....
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Top Tip Bio is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to www.amazon.com. We will earn a commission from Amazon if a purchase is made through the affiliate links.
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
thank you so much this really helped me with my last Psych statistics assignment and you explained it very well.
Never left a comment before, but thank you very much. Our teacher was trying to make us to do this manually in Excell
Great! Its important to remember that one does this when data is ordinal
Wow thank you for this! Helps a lot in my online assessments
Can't thank you enough for this amazing video....made it so easy to use the test..thank you 🤗
This is SOOOOO helpful! Thank you so much for posting.
Very welcome Cassie
Thank you for this, very helpful. Still not clear on 1 or 2 tailed test but that seems to be a tough one.
Thank you for explaining how to interpret the results, not just do them. this helped so much.
Great tutorial! This tutorial helped me alot. Thank you!
Ok this is another great way of remembering this procedure when the data is ordinal
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
Thank you a lot, it was super useful! your way to explain is awesome
Thanks :)
Thank you so much. You are heaven sent!
Very well explained, thank you
Thank you, very helpful
Can i use this for likert scale values ?
Really helpful! Thank you!
You can lock column and row together by simply clicking F4.
don´t you need to put the ranking in order before?
Omg Thank You so so much. It literally helped me pass.😭🌻🌞❤
Very welcome Shravani!
hi, may i ask how to rank three same data? :((
how is the degrees of freedom formula not: (n-1)
hi, may I know if there is a paper that I can cite for the formula for t-statistic?
Fantastic video!
Thanks for saving 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?
THANK YOU SO MUCH!
Can this be used for two likert scale data?
Is there a way to do this faster, I have a lot more values
What does the t-statistic and p-value mean?
saved my life!!
Very good!
Thank you so much
Thank you sir
very helpful!
Thank You
You saved me
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?
thanks man
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.
THANK YOU.
Especially for the explanation.
my coefficiant is -1 and bcus of this i cant find my t statistic why?
you should take abs value
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.
HI! WHY DOES IT SHOW WRONG FORMULA FOR ME?
Hi, have you solved it?
My is showing #name?
I use to suffer from statistics
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.