College Admission Rates pt. 2

I added more colleges to my CAR spreadsheet: the rest of the Ivies, other top universities, and top undergraduate business schools. Below is the updated graph:

*Dyson (The School of Applied Economics and Management at Cornell University) is very far from the line of best fit. Including it single-handedly dropped the line's r-squared value from .953 to .914.

The points are more densely placed on the graph, so the university labels for each point may overlap. However, I learned how to sort ranges by numerical value this week. Below is the updated spreadsheet. The order of universities from the below list's top to its bottom is the order of universities from the above graph's left to its right.

*I actually first learned how to sort in Excel. In Google Sheets, the only options for sorting are A to Z and Z to A, which are apparently the way to sort by numerical value. Before learning that, I was getting frustrated because I could not find a clearly labeled number sorting tool equivalent to the one I found in Excel.

Excel probably has more tools than Sheets, which is not necessarily good; I usually make rather simple calculations or graphs, so Sheets is easier to use because of its fewer functions.

The sheet below displays those colleges' DIS calculations, a method of determining quality used in the article Instate vs. Out-of-State Admission Bias:

*I had to make this on Excel because Sheets' sorting tool was malfunctioning.

Surprisingly, the corresponding chart is nearly linear:

I suppose it makes sense: for the very top colleges, SAT percentile does not change much, making DIS strongly associate with Reject Rate. DIS likely does not allow users to see clear differences in selectivity especially among the very top colleges. My method in College Admission Rates seems better for this purpose as it compares relative SAT takers and applicants per admit.