THE ONLINE GUIDE toptipbio.com/spearman-correlation-excel/
@CH-dm1po
4 жыл бұрын
This is incredibly helpful. Everything is explained really clearly so I actually understand the reason behind each step. Thank you!
@StevenBradburn
4 жыл бұрын
Excellent! So glad it was helpful for you :)
@noemiszebenszki7508
3 жыл бұрын
I am doing a university project and this video saved me, thank you! It was very useful and easy to understand!
@StevenBradburn
3 жыл бұрын
Excellent. Thanks for the feedback. Good luck with your project
@glitterwitch19
3 жыл бұрын
Never left a comment before, but thank you very much. Our teacher was trying to make us to do this manually in Excell
@judybrowes2102
Ай бұрын
thank you so much this really helped me with my last Psych statistics assignment and you explained it very well.
@bernsbuenaobra473
4 жыл бұрын
Great! Its important to remember that one does this when data is ordinal
@raphaelsimbulan57
3 жыл бұрын
Wow thank you for this! Helps a lot in my online assessments
@cassieklein6772
2 жыл бұрын
This is SOOOOO helpful! Thank you so much for posting.
@StevenBradburn
2 жыл бұрын
Very welcome Cassie
@minivashist
2 жыл бұрын
Can't thank you enough for this amazing video....made it so easy to use the test..thank you 🤗
@anndiamond7601
3 жыл бұрын
Thank you so much. You are heaven sent!
@pavelrogozin108
3 жыл бұрын
Thank you, very helpful
@nastya-ananastya1832
3 жыл бұрын
Thank you a lot, it was super useful! your way to explain is awesome
@StevenBradburn
3 жыл бұрын
Thanks :)
@bernsbuenaobra473
4 жыл бұрын
Ok this is another great way of remembering this procedure when the data is ordinal
@guhgondor6468
2 жыл бұрын
Great tutorial! This tutorial helped me alot. Thank you!
@scottdiver690
Жыл бұрын
Thank you for this, very helpful. Still not clear on 1 or 2 tailed test but that seems to be a tough one.
@S.12123
Жыл бұрын
Very well explained, thank you
@somnolent4339
2 жыл бұрын
Thank you for explaining how to interpret the results, not just do them. this helped so much.
@ohbennyboy
Жыл бұрын
Really helpful! Thank you!
@phoebekatesmeleciodelicana2252
2 жыл бұрын
Thanks for saving me!🙏💕
@ogunwusijohn1909
3 жыл бұрын
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
@StevenBradburn
3 жыл бұрын
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
@jiaqint961
8 ай бұрын
Fantastic video!
@hazelarcega3337
2 жыл бұрын
THANK YOU SO MUCH!
@RaoShravani
3 жыл бұрын
Omg Thank You so so much. It literally helped me pass.😭🌻🌞❤
@StevenBradburn
3 жыл бұрын
Very welcome Shravani!
@elliejoensen2695
3 жыл бұрын
saved my life!!
@eueueqi
2 жыл бұрын
Can i use this for likert scale values ?
@kendesmarais9018
5 ай бұрын
You can lock column and row together by simply clicking F4.
@samdavison-wall4972
2 жыл бұрын
Very good!
@smsmsmsmsmsm
3 жыл бұрын
Thank you so much
@elliot1453
3 жыл бұрын
very helpful!
@carolineguerra7655
2 жыл бұрын
Thank you sir
@angelostaana8749
3 жыл бұрын
hi, may i ask how to rank three same data? :((
@reyarcite4286
3 жыл бұрын
Thank You
@nickluo75
2 жыл бұрын
thanks man
@JustDeidei
Жыл бұрын
You saved me
@mustafadar6266
2 ай бұрын
how is the degrees of freedom formula not: (n-1)
@Mr-mr-mr10
4 жыл бұрын
THANK YOU.
@Mr-mr-mr10
4 жыл бұрын
Especially for the explanation.
@mifeijoo
2 ай бұрын
don´t you need to put the ranking in order before?
@inaoville3115
2 жыл бұрын
Can this be used for two likert scale data?
@JRZans
3 жыл бұрын
Does it have to be a 2 tailed test every time? Or choosing 1 or 2 tailed test does not really matter that much?
@boblee1401
Жыл бұрын
hi, may I know if there is a paper that I can cite for the formula for t-statistic?
@alexm8859
3 жыл бұрын
Is there a way to do this faster, I have a lot more values
@zaynabwaraich1738
2 жыл бұрын
What does the t-statistic and p-value mean?
@wnaish7541
3 жыл бұрын
it just says #value! in the cell?
@LoffysDomain
4 жыл бұрын
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?
@1997alimaster
4 жыл бұрын
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.
@elliot1453
3 жыл бұрын
@@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.
@sayyedataki5499
3 жыл бұрын
my coefficiant is -1 and bcus of this i cant find my t statistic why?
@naila0899
2 жыл бұрын
you should take abs value
@sebastianszereday6073
2 жыл бұрын
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
2 жыл бұрын
Hi Sebastian. I would not advise to perform correlation analysis with only 3 samples
@sebastianszereday6073
2 жыл бұрын
@@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?
@veehangisingh5159
4 жыл бұрын
HI! WHY DOES IT SHOW WRONG FORMULA FOR ME?
@alexandrufilipescu1301
3 жыл бұрын
Hi, have you solved it?
@charanpreetkaur3148
2 жыл бұрын
My p value is coming 3.4584E-19. How can I interpret it
@samsg
Жыл бұрын
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.
@bulbulroy8812
2 жыл бұрын
My is showing #name?
@drealslimshady
3 жыл бұрын
i love u
@winter_armamenter
3 жыл бұрын
I use to suffer from statistics
@RayanKhan
3 жыл бұрын
My T statistic is showing #num!
@StevenBradburn
3 жыл бұрын
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
@eueueqi
2 жыл бұрын
@@StevenBradburn hi why is it even if I have included the ABS function, it still shows #num! ?
@zeldaweeb1738
3 ай бұрын
@@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.
Пікірлер: 69