• Set Yourself Up For Success Webinar

    October 6, 2021 at 2 PM Eastern/11 AM Pacific
    SDN and Osmosis are teaming up to help you get set up for success this school year! We'll be covering study tips, healthy habits, and meeting mentors.

    Register Now!

  • Site Updates Coming Soon

    Site updates are coming next week on Monday, Wednesday, and Friday. Click the button below to learn more!

    LEARN MORE

US News 2003, 2004, 2005 Med Rankings on Excel

exmike

NOR * CAL
10+ Year Member
15+ Year Member
May 19, 2003
4,206
11
211
43
Bay Area
  1. Fellow [Any Field]
I think some of you stats / rankings lovers will get a kick out of this. I put the last three years of US News rankings into an excel sheet. Now you guys dont have to ask for it or buy it. You can notice some interesting trends between the years. Sorting by category produces some interesting results too. ENJOY!

U.S. News 2003, 2003, 2005 Rankings on Excel

p.s. Each Year is on a different sheet, so you can tab through the three sheets.
 
Upvote 0
E

Eraserhead

exmike said:
I think some of you stats / rankings lovers will get a kick out of this. I put the last three years of US News rankings into an excel sheet. Now you guys dont have to ask for it or buy it. You can notice some interesting trends between the years. Sorting by category produces some interesting results too. ENJOY!

U.S. News 2003, 2003, 2005 Rankings on Excel

p.s. Each Year is on a different sheet, so you can tab through the three sheets.

You're just trying to get more Karma points!

Hey I already paid for these, dammit... but this won't open on my computer I don't know why.
 
Upvote 0
About the Ads

Scooby Doo

IEatShavedPussyCats
10+ Year Member
15+ Year Member
Jul 10, 2001
3,797
1
0
City
noclouds said:
thanks for sharing the data and putting it all into excel! :)

just one thing though --- where are the 2004 and 2005 columns for "% of class getting top 3 residency choices"?

or why has US news stopped gathering that data? :confused:

thanks again!!

Top 3 residency is total crap...don't even pay attention to it...it's a skewed process that doesn't matter. Almost everyone at every school will get their top 3 b/c u aren't interviewed unless you have a decent chance..and if the school is going to guide you as to where you can apply....top choices are only based on where you interview...hence, every school is like 80 to 90%...a total waste of research for anyone.... btw, Rankings matter...but not to the extent that a #4 school is any better than a # 9 school....Go based on how you felt about the school, the environment, the rank, etc etc....in whatever order you have to do it...
 
Upvote 0
About the Ads

Spitting Camel

Anteater for Life!
7+ Year Member
15+ Year Member
Nov 6, 2003
1,847
2
0
'Eaterville
10minutes said:
Whoa, I didn't know my school has faculty/student ratio- 1.5. That's great. We also have a high residency point. Cool!

Isn't the 1.5 ratio small? BU only has 1.8 faculty to each student. Some schools have 6,7 or 8 faculty for every student... hmmm... Am I analyzing this wrong? :confused:
 
Upvote 0

snapdad

Rock and Roll Doctor
10+ Year Member
15+ Year Member
Oct 31, 2003
607
0
201
  1. Non-Student
exmike said:
I think some of you stats / rankings lovers will get a kick out of this. I put the last three years of US News rankings into an excel sheet. Now you guys dont have to ask for it or buy it. You can notice some interesting trends between the years. Sorting by category produces some interesting results too. ENJOY!

Very very cool. Thanks! :thumbup:
 
Upvote 0

Spitting Camel

Anteater for Life!
7+ Year Member
15+ Year Member
Nov 6, 2003
1,847
2
0
'Eaterville
Dr. I Bleed Blue and Gold said:
this is great! thanks!

What's great is your screen name! I LOVE it! :laugh: :clap: :laugh: Every School I have ever gone to has been blue and gold! I've been a Crusader, Monarch, Baron, Anteater, and now Boston(?) Does anyone know their colors? If they're not blue and gold, I may have to withdraw... What's their mascot, anyway?
 
Upvote 0

exmike

NOR * CAL
10+ Year Member
15+ Year Member
May 19, 2003
4,206
11
211
43
Bay Area
  1. Fellow [Any Field]
CalBeE said:
Mike,

What happened to your med school predictions? Are they no longer valid? :(

How do you have so much time to do stuff like that? Sometimes I feel that I got so busy that I rarely have time to eat at all...

Hehe, i thought noone was looking at them anymore, so i took them down. want them back up?


And i have a lot of free time now. I dont worry much about my ms program anymore. man i cant wait to start med school!
 
Upvote 0

Eyecon82

Senior Member
7+ Year Member
15+ Year Member
Nov 3, 2003
450
2
0
exmike said:
I think some of you stats / rankings lovers will get a kick out of this. I put the last three years of US News rankings into an excel sheet. Now you guys dont have to ask for it or buy it. You can notice some interesting trends between the years. Sorting by category produces some interesting results too. ENJOY!

U.S. News 2003, 2003, 2005 Rankings on Excel

p.s. Each Year is on a different sheet, so you can tab through the three sheets.

Thanks man...that was very thoughtful of you! Can someone please tell me what this karma thing is all about? isn't karma supposed to be a bad thing?
 
Upvote 0

pekq

Gunner
7+ Year Member
15+ Year Member
Jan 26, 2004
360
2
0
NJ
Is it accurate to calculate total faculty based on fac/stu ratio multiplied by total students? I am trying to calculate the NIH/Fac ratio as some ppl have said that US News should consider it as a factor. According to preliminary analysis, UCSD would get quite a boost if this was factored in.
 
Upvote 0

jjmack

Senior Member
15+ Year Member
Mar 3, 2003
822
12
261
LA
  1. MD/PhD Student
  2. Resident [Any Field]
That is an interesting idea, but it would be better if there were some way to only factor in fac who do research. I'm not totally certain, but think some fac at schools with larger hospitals are almost totally clinical.

pekq said:
Is it accurate to calculate total faculty based on fac/stu ratio multiplied by total students? I am trying to calculate the NIH/Fac ratio as some ppl have said that US News should consider it as a factor. According to preliminary analysis, UCSD would get quite a boost if this was factored in.
 
Upvote 0
About the Ads

CalBeE

Full Member
7+ Year Member
15+ Year Member
Dec 14, 2003
2,062
1
0
WstSdDesi said:
Thanks man...that was very thoughtful of you! Can someone please tell me what this karma thing is all about? isn't karma supposed to be a bad thing?
Karma is a Neutral term, like "Temperature", or "History". It's basically a record of what you have done in the past, whether in this life, or in your past life (i.e. Changing your screen name won't erase your past!). Hence you can earn BAD or GOOD karma for your actions.
 
Upvote 0

exmike

NOR * CAL
10+ Year Member
15+ Year Member
May 19, 2003
4,206
11
211
43
Bay Area
  1. Fellow [Any Field]
pekq said:
Is it accurate to calculate total faculty based on fac/stu ratio multiplied by total students? I am trying to calculate the NIH/Fac ratio as some ppl have said that US News should consider it as a factor. According to preliminary analysis, UCSD would get quite a boost if this was factored in.


Maybe you should forward that idea to US News so they can change the methodolgy and throw the rankings world into turmoil.
 
Upvote 0

med9812

New Member
15+ Year Member
Apr 15, 2004
3
0
0
Awesome work! Any chance you have the complete list of Pediatrics ranks for each year? (or at least for 2005?) Thanks!

exmike said:
I think some of you stats / rankings lovers will get a kick out of this. I put the last three years of US News rankings into an excel sheet. Now you guys dont have to ask for it or buy it. You can notice some interesting trends between the years. Sorting by category produces some interesting results too. ENJOY!

U.S. News 2003, 2003, 2005 Rankings on Excel

p.s. Each Year is on a different sheet, so you can tab through the three sheets.
:) :)
 
Upvote 0

pekq

Gunner
7+ Year Member
15+ Year Member
Jan 26, 2004
360
2
0
NJ
exmike said:
Maybe you should forward that idea to US News so they can change the methodolgy and throw the rankings world into turmoil.

If they did that, Harvard would lose #1 and washu would replace them :eek:
There's no way US News would ever do anything that'd displace Harvard from #1 cause Harvard bribes them with acceptances ;)
 
Upvote 0

RAwe

Senior Member
10+ Year Member
15+ Year Member
Feb 17, 2004
111
0
201
exmike said:
I think some of you stats / rankings lovers will get a kick out of this. I put the last three years of US News rankings into an excel sheet. Now you guys dont have to ask for it or buy it. You can notice some interesting trends between the years. Sorting by category produces some interesting results too. ENJOY!

U.S. News 2003, 2003, 2005 Rankings on Excel

p.s. Each Year is on a different sheet, so you can tab through the three sheets.



Way to go Exmike...Thanx :clap:
 
Upvote 0

jjmack

Senior Member
15+ Year Member
Mar 3, 2003
822
12
261
LA
  1. MD/PhD Student
  2. Resident [Any Field]
I would love to watch the wash u bashers find a way to bash them on having too much funding per PI.

pekq said:
If they did that, Harvard would lose #1 and washu would replace them :eek:
There's no way US News would ever do anything that'd displace Harvard from #1 cause Harvard bribes them with acceptances ;)
 
Upvote 0

Mr Reddly

Snowglobe!
7+ Year Member
15+ Year Member
Jan 14, 2004
900
2
0
Still trying
exmike said:
I think some of you stats / rankings lovers will get a kick out of this. I put the last three years of US News rankings into an excel sheet. Now you guys dont have to ask for it or buy it. You can notice some interesting trends between the years. Sorting by category produces some interesting results too. ENJOY!

U.S. News 2003, 2003, 2005 Rankings on Excel

p.s. Each Year is on a different sheet, so you can tab through the three sheets.
OMFG!!! You put a Macro Virus in there!!! Now I have to detox my labtop!!! Ooooooh Big Time Negative Karma points for you mister!!!











...(j/k) :D
 
Upvote 0
About the Ads
This thread is more than 17 years old.

Your message may be considered spam for the following reasons:

  1. Your new thread title is very short, and likely is unhelpful.
  2. Your reply is very short and likely does not add anything to the thread.
  3. Your reply is very long and likely does not add anything to the thread.
  4. It is very likely that it does not need any further discussion and thus bumping it serves no purpose.
  5. Your message is mostly quotes or spoilers.
  6. Your reply has occurred very quickly after a previous reply and likely does not add anything to the thread.
  7. This thread is locked.