US News 2003, 2004, 2005 Med Rankings on Excel

[exmike]

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.

---

Members don't see this ad.

 

[Eraserhead]

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.

 

[Eraserhead]

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.

Oh, nevermind, now it opens.

 

[Tezzie]

Great post Mike !

I would have given you a karma point but it seems i've given out too many already!

 

[Samus Aran]

Does anyone know if the GPA reported for each school is their average science or overall GPA?

 

[exmike]

Does anyone know if the GPA reported for each school is their average science or overall GPA?

Its the overall GPA

 

[Tezzie]

Overall Misty!

 

[Samus Aran]

Thank God for that...

 

[Blade28]

Thank you very much!

Karma for you!

 

[noclouds]

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?

thanks again!!

 

[10minutes]

Whoa, I didn't know my school has faculty/student ratio- 1.5. That's great. We also have a high residency point. Cool!

 

[Scooby Doo]

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?

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...

 

[CalBeE]

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...

 

[Spitting Camel]

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?

 

[snapdad]

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!

 

[FrankMD]

this is great! thanks!

 

[Spitting Camel]

this is great! thanks!

What's great is your screen name! I LOVE it! 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?

 

[10minutes]

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?

Maybe you are right, shoot!

 

[exmike]

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!

 

[dhooppi]

you da man!!!

 

[Eyecon82]

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?

 

[pekq]

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.

 

[jjmack]

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.

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.

 

[CalBeE]

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.

 

[exmike]

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.

 

[med9812]

Awesome work! Any chance you have the complete list of Pediatrics ranks for each year? (or at least for 2005?) Thanks!

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.

 

[jlee9531]

and now i see why mike is the top karma getting on the entire site of sdn...

 

[pekq]

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
There's no way US News would ever do anything that'd displace Harvard from #1 cause Harvard bribes them with acceptances

 

[RAwe]

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

 

[jjmack]

I would love to watch the wash u bashers find a way to bash them on having too much funding per PI.

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

 

[pekq]

Maybe a better gauge of quality of research would be ratio of publication in a prestigious journal (eg. C/N/S) to # of PI. Then Harvard would probably retain first place. Again, UCSD would shoot up.

 

[eyeful]

excellent. thanks.

 

[Mr Reddly]

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)

 

[moops]

why do they rank a diff number of schools each year?

 

[klooless]

For 2005, you have Stanford at #9. However, it's actually tied at #8 with Columbia (rather than Columbia being tied at #7 with U Mich).

 

[Scooby Doo]

For 2005, you have Stanford at #9. However, it's actually tied at #8 with Columbia (rather than Columbia being tied at #7 with U Mich).

Fuk stanfurd

 

[klooless]

Fuk stanfurd

Any particular reason, or are you just feeling hostile?

 

[Scooby Doo]

Any particular reason, or are you just feeling hostile?

Go BEARS!

 

[klooless]

gotcha.....