Using Excel graphs to fuel your existential crisis
Here’s how I’m procrastinating these days:
One of the local grads is having an existential crisis. I’m never going to get a job. I should never have come here. I shouldn’t have gone to grad school period. etc. etc. We’ll all been there. I attempted to cheer her up just as she hit the “no job if your advisor isn’t famous” gripe. During that exchange she took advantage of my well known weakness for
wasting spending time playing around with stats and got me to make a few graphs. Ok, so you don’t have to twist my arm for me to spend time on some analysis having nothing to do with my research. That’s how I ended up as a “statistical consultant” for a local coffee shop (they paid me in delicious sandwiches). Anywho, grad student got me to make the following:
(click to greatly embiggen)
Thats of representation of where the profs at some “top 5” department go their doctorates. Each line is one faculty, where the left point is the rank of the department and the right point the rank of that persons graduate alma matter (rank via usnews). The red dashed line is the median faculty. So the higher the slope the more a department takes faculty from higher ranked programs.
For comparison here are three other departments
Why have we made these graphs? I have no idea. They look pretty and we wanted to actually know where the profs at a few departments had gotten their doctorates (rather than rely on rumor and reputations).