I wanted to follow up with some grade data of students after admission. The admissions data I'm using was from PeopleSoft (the PS table prefixes), so I've relied on matching up the PS "EMPLID" columns to correlate data from different tables. Unfortunately most grade data (eg per-course) isn't PeopleSoft so it's not that easy there. However, one table was. PS_DWSA_DEGREES has 350,606 records of degrees awarded, including the relevant GPA.
From this I've got data of average GPA of graduated students. This has a selection bias of only those that successfully graduated, but still useful.
Also with a new race I forgot to include last time, Pacific islanders.
@niggy Amazing work, my friend! I'm not sure if you ever saw it because you've been away for so long but I want to show you the clay Watamelon that I made. It was even acknowledged with a like by Watame herself!
Computer Niggy Exploitation (CNE) access was obtained to the University of Minnesota's data warehouse. Within this massive Oracle SQL database system they store basically all important records the university has kept since they begin digitizing in 1989. Student/faculty PII, grades, and most importantly here admissions data with diversity statistics
After exfiltrating data, I set up a local database with the relevant tables imported from, and queried it to get various statistics on affirmative action at UMN.
Joining the PS_DIVERSITY and PS_DWAD_APPL_HS tables I was able to query the average ACT scores of admitted applicants of each racial category, with admissions excluded pre-2010 to keep it contemporary. A graph of results is included here.
The results are of course largely expected, showing for example a White/Asian applicant must have a significantly higher ACT to be admitted than a black applicant.
Interestingly a White/Asian applicant only gets some benefit from not specifying their race, likely because only White/Asian applicants don't.
@jmw150@niggy Steve Sailer and his commentators have been discussing this from a different angle, how the SAT is getting changed as of late and how a huge 40 point bump in scores for Asians can only be explained by the tests becoming something you can really study for.
Compare as an extreme the pre-1994 SAT which was a very accurate proxy for IQ, although for the verbal test you needed to be well read/have a large and accurate vocabulary.
@ThatWouldBeTelling@niggy It seems like some of the 40 point bump can be explained by excluding pacific islanders, but not a lot. Wish we could do that for underperforming European nationalities though, just no-true-scotsman our statistics until agreeable answers come out.
@niggy Realistic indicator of Asians overstudying to get into a western school, instead of genuine smarts. But the bias is low enough here to not be irritating.
Also I wonder if gpa requirements on majors have been waived at this school for niggers, or if they simply choose derivative majors to survive. Topic choice and drop rate would be interesting to find.