TheChai Posted January 29, 2005 Report Share Posted January 29, 2005 (edited) right i need to know if i can calculate spearmans rank easily on excel if soo can someone give me a little guidance on to how? i know there is a rank function and if someone taught me how to use that it would be great help as well thanks alots :ermm: Edited January 29, 2005 by TheChai Quote Link to comment Share on other sites More sharing options...
Hiltop Posted January 29, 2005 Report Share Posted January 29, 2005 i dont think you can i needed to do it for a geography project but had to use another progam instead. maybe im wrong though, there may well be a way of doing it but nobody i could find knew how. Quote Link to comment Share on other sites More sharing options...
JT! Posted January 29, 2005 Report Share Posted January 29, 2005 I DID! Its took ages, but if you know how to use excel well, you can do it, with very little effort. I can remember you have to arrange them into rank order and then number them, i have 50 amounts of data, and did it all on excel in about 10 mins. (Got an A) Quote Link to comment Share on other sites More sharing options...
Haz Posted January 29, 2005 Report Share Posted January 29, 2005 Mmmm, statistics coursework... :D I remember doing that, I'll do the forumla for you in excel tomorrow and I can send the file over msn if you want? Too late now and I have family lunch tomorrow (again :D ), so let me know if it's too late for you... :D Quote Link to comment Share on other sites More sharing options...
rocktrials Posted January 30, 2005 Report Share Posted January 30, 2005 spearmen's rank correl is piss! you have that in coursework? at A level? we dot do coursework, we just have 4 exams over 2 years Quote Link to comment Share on other sites More sharing options...
TheChai Posted January 30, 2005 Author Report Share Posted January 30, 2005 nah its gcse course work... got it working now :D Quote Link to comment Share on other sites More sharing options...
Sameer Posted January 30, 2005 Report Share Posted January 30, 2005 ^^ That's one sick f**ker of an email address. :D :D Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.