[This article was first published on Adventures in Analytics and Visualization, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
Link to the code for the analysis program is given at the very end.
I teach in a business school and am always fascinated by rankings published by different outlets. As much as one would like to think that they are meaningless, they seem to influence how many business schools actively try to manage their reputation. One such ranking of undergraduate business schools was recently published by Bloomberg Businessweek. I thought I’ll take a closer look at the numbers and try to present my analyses using only graphs and charts. The Businessweek article presented table(s) on their website. I have recreated that table below. (You can click on any column header to sort the table based on that column.)
2. There are few states, which are not represented in the ranking.
Remember, a school with a higher index number was better ranked. Here, we look at how index numbers were distributed across different states. To do this, we use boxplots, which show the minimum, maximum, 25th percentile, 50th percentile (median), and the 75th percentile of the distribution. The blue dots in the middle of the box are the mean index scores.
1. Average scores are increasing from Vermont to Indiana.
2. Spread of the distribution (to some extent, measured by how long each box is) appears to vary across different states (for states with only one school, it is just a single point, but for states with multiple schools, the spread indicates the higher variance in the index scores across schools in that state.
1. As one should expect, job placement grade and teaching quality grade matter. Facilities and services grade also has an effect.
2. Private schools appear to have a higher index number than public schools.
Observations
1. 2013 Rank is, as expected, positively correlated with how schools are ranked by students and employers (not too dark a blue, is it?), MBA feeder school and Academic quality rank
2. 2013 Rank is perfectly negatively related to Index Number (hence the , because of the way it is computed).
3. Index Number is marginally positively correlated with Annual Tuition (not a good thing, is it?), but has a positive relationship with median starting salary of students. The latter relationship is a good thing.
4. Index number is negatively related to student faculty ratio, which is also a good thing, right? How does this play into the MOOCs thing?
5. And yes, the average SAT scores are strongly related to the index number.
Now, this gets interesting. Since there are many combinations possible and everyone has their own pet set of issues, the following interactive chart will let you play around until …. forever, if you are really ticked about these issues.
This chart can be played around with in the following ways.
1. The two small tabs on the top right show either bubble charts or bar graphs, depending on what’s selected.
2. The horizontal and vertical axes can be changed to other variables by clicking at existing axis labels (the arrow mark)
3. You can hover over the dots to know the school and value of the variables being examined.
4. Color is used to identify whether a school is a public school (Green) or a private one (Blue).
5. Size of dot is based on the index number- LARGER size is a better ranked school with a higher index number.
Observations: I will let you make them. Have fun.
The R code for this analysis can be accessed by clicking this link.
I teach in a business school and am always fascinated by rankings published by different outlets. As much as one would like to think that they are meaningless, they seem to influence how many business schools actively try to manage their reputation. One such ranking of undergraduate business schools was recently published by Bloomberg Businessweek. I thought I’ll take a closer look at the numbers and try to present my analyses using only graphs and charts. The Businessweek article presented table(s) on their website. I have recreated that table below. (You can click on any column header to sort the table based on that column.)
How many schools are ranked in different States?
Below is the US map color coded based on number of schools in different States. Since Washington DC is small to be on the larger map, that region gets its own smaller map. (You may have to scroll to the right.)
Few observations
1. Ohio has the highest number of schools represented in this ranking.
Few observations
2. There are few states, which are not represented in the ranking.
Distribution of Index Numbers by State
Remember, a school with a higher index number was better ranked. Here, we look at how index numbers were distributed across different states. To do this, we use boxplots, which show the minimum, maximum, 25th percentile, 50th percentile (median), and the 75th percentile of the distribution. The blue dots in the middle of the box are the mean index scores.
1. Average scores are increasing from Vermont to Indiana.
2. Spread of the distribution (to some extent, measured by how long each box is) appears to vary across different states (for states with only one school, it is just a single point, but for states with multiple schools, the spread indicates the higher variance in the index scores across schools in that state.
Distribution of Index Numbers by Type of School, Teaching Quality Grade, Facilities and Services Grade, and Job Placement Grade
1. As one should expect, job placement grade and teaching quality grade matter. Facilities and services grade also has an effect.
2. Private schools appear to have a higher index number than public schools.
Relationships between Different Ranks, Index Numbers, a whole host of other variables
Here, we will look at a correlation analysis. (I’ve clubbed rank-ordered variables with ratio-scaled ones, but come on.) Below, is a graph with correlation coefficients color coded based on their value. Positive coefficients have been coded in blue and negative ones in red. Intensity of colors indicate the value.
Observations
1. 2013 Rank is, as expected, positively correlated with how schools are ranked by students and employers (not too dark a blue, is it?), MBA feeder school and Academic quality rank
2. 2013 Rank is perfectly negatively related to Index Number (hence the , because of the way it is computed).
3. Index Number is marginally positively correlated with Annual Tuition (not a good thing, is it?), but has a positive relationship with median starting salary of students. The latter relationship is a good thing.
4. Index number is negatively related to student faculty ratio, which is also a good thing, right? How does this play into the MOOCs thing?
5. And yes, the average SAT scores are strongly related to the index number.
Schools positioned on any set of two variables
Now, this gets interesting. Since there are many combinations possible and everyone has their own pet set of issues, the following interactive chart will let you play around until …. forever, if you are really ticked about these issues.
This chart can be played around with in the following ways.
1. The two small tabs on the top right show either bubble charts or bar graphs, depending on what’s selected.
2. The horizontal and vertical axes can be changed to other variables by clicking at existing axis labels (the arrow mark)
3. You can hover over the dots to know the school and value of the variables being examined.
4. Color is used to identify whether a school is a public school (Green) or a private one (Blue).
5. Size of dot is based on the index number- LARGER size is a better ranked school with a higher index number.
Observations: I will let you make them. Have fun.
The R code for this analysis can be accessed by clicking this link.
To leave a comment for the author, please follow the link and comment on their blog: Adventures in Analytics and Visualization.
R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.