<p>Link: <a href="http://goo.gl/M62tc1">http://goo.gl/M62tc1</a></p>
<p>Every year, the National Merit Scholarship Corporation releases their Annual Report (<a href="http://www.nationalmerit.org/annual_report.pdf">http://www.nationalmerit.org/annual_report.pdf</a>). In it (amongst other things), they list colleges National Merit/Achievement Scholars will attend in the fall and differentiate between NMSC/corporate-sponsored National Merit Scholars and school-sponsored National Merit Scholars. The latest version is from 2013, which corresponds with the Class of 2017 and the incoming freshmen of Fall 2013.</p>
<p>I went through and took the number of non-school-sponsored National Merit and Achivement Scholars at each listed college and found the number of first-time/full-time freshmen entering the college that same fall (using Common Data Sets when I could find them, and other reliable sources when I couldn't). I excluded school-sponsored National Merit Scholars because not every school offers such sponsorship and because including them would skew the data even more in favor of schools like OU (second-tier flagships and non-flagship state schools) because they tend to offer more aid more frequently for National Merit Finalists. Beyond that, including them would mean the data doesn't track a coherent set of individuals- students' inclusion in the data set would vary based on whether they went to a school like OU or UTD. Instead, I opted to track the decisions of students who'd already received corporate-sponsored (1029 students) or NMSC-sponsored (2500 students) scholarships to see what colleges they picked. This doesn't correspond solely with college quality, of course, since finances are a big factor- especially when you get full rides + stipends thrown at you from some places. There might also be some stipulations in corporate-sponsored scholarships that would skew the data, but I eliminated all the issues I could.</p>
<p>Then I adjusted the numbers based on the size of the incoming freshman class (full-time, first-time only since intending to enroll full-time is a prerequisite for the National Merit Scholarship). You can see the results in the spreadsheet, which you can sort by %Scholar (default), %Merit (excluding Achievement Scholars), and %Achievement (exluding Merit Scholars). The colleges are ranked on the left, of course, and the columns on the far right also tell you what portion of a school's incoming Scholars consists of Merit Scholars or of Achievement Scholars ("Merit/Scholar (%)" and "Achievement/Scholar (%)").</p>
<p>Unsurprisingly, Harvard comes out on top when you look at all Scholars, Caltech when only at Merit Scholars, and Yale when only at Achievement Scholars. Hope this serves as a small resource in your college search.</p>