Spearman's Rank Excel 2007

[HarunoSakuraL]

this helped me so much - thank you!!!

[LifeUpInTheSky]

Does it matter if you rank them smallest to largest or vice versa. I ask because I recieve different results whe doing so...

[xBhayBie]

Just found this video luckily (I have an exam in a few days). Very good video, I understand how to do this now, thank you.

[chocolateicecream221]

It's too quiet man. That sucked, because this video is just... the best.

[MissAlishaMay1]

thank u so much!!!1

[MrRustyBearings]

omg thank you so much you saved my life!!!

[rachelleandrajashree]

@bradley8cfc you're cool.

[bradley8cfc]

Thumbs up if you watched this for your Statistics Coursework at Doha College

[yyaannaall1]

@bradley8cfc such a gay philipino boy

[rachellexdiab]

@yyaannaall1 LOL

[ninja2156]

2:12 killed me i had my speakers up :(

[yyaannaall1]

@ninja2156 haha same too i had my headphones on :(

[Akino2Onika]

excellent tutorial! very clear and easy to follow! good job

[chuvaforte]

Fantastic! congratulations for the video!

[Plotit96]

Top Notch Stuff!

[MikeTsan]

thanks. just what i was looking for!

[RandomSN188]

You talk quietly... and every now and then there's this awfully loud static click. This is murder for someone with headphones. Aside from that, very informative, cheers.

[musti380]

thak you!

[charliem1077]

Thankyou, best tutorial on youtube.

=)

[MariannaKhanBeauty]

THANK YOU SOOOOO MUCH, I have to hand in my BSc Geography Soil Report tomorrow and have been struggling to do this for quite some time. This is the most useful tutorial I have found on the internet-will be forwarding your video to all my Geo friends :D

Thanks again!!!

[stephaniekeyte]

You just rescued my statistics coursework

You saviour

[jayhant]

Thanks for the help!

[MeowThePurpleNinja]

Yh, like that Kester Brewin guy was saying it doesn't deal with tied ranks, so what do you do?

[savidislps]

why not just use the rank function =rank(B$3:B$21) - this could then be copied into the two columns rather than sorting?

[Galilani]

Thanks so much! This was very helpful!! :)

[davidhatcher9]

Thank fuuuck for this <3

[lhmlhmlhm]

thank you very much!!! that´s exactly what i was looking for!

thanks!

[andrewarchibald89]

thanks very much

[rivasplata83]

Gracias, me ayudaste con mi tesis!!

[RinseUseBang]

You actually just saved my life doing last minute Statistics Coursework!

You are brilliant!

[Ulterior24]

yes, i have the same problem as pearceytheguy, what about repeats? :S

[pearceytheguy]

thats all well and good; but how do i deal with repeats of data regarding the ranking?

[PQK]

Thanks for posting this video. Helped edify the use of Spearman's rho in a practical situation!

[LilRach1234]

Thank you so much! We do statistics are part of our school work - I have already tried attempting this myself 4 times and done it wrong! Thank you so much - You've saved me time and made my life easier! 5 stars! :) Xx

[wildechild123]

i used this to :L