:niggy: on Nostr: After exfiltrating data, I set up a local database with the relevant tables imported ...
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.
Published at
2023-07-09 03:23:53Event JSON
{
"id": "c0bc247ffd4748a8cd5c684285ce55eb65a9c5bf309d6f9cb5ce3b20635f4821",
"pubkey": "6be61ca6c65a6d80ae4deb98eb27943cba1bc93dfc975b8161028c099c2b54dc",
"created_at": 1688873033,
"kind": 1,
"tags": [
[
"p",
"6be61ca6c65a6d80ae4deb98eb27943cba1bc93dfc975b8161028c099c2b54dc",
"wss://relay.mostr.pub"
],
[
"e",
"16eed971728d248acaea4b42658757eead61068ccb876da3c6095ec87a1308d0",
"wss://relay.mostr.pub",
"reply"
],
[
"mostr",
"https://poa.st/objects/72266a86-66ff-4941-8206-48f8bd432612"
]
],
"content": "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.\n\nJoining 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.\n\nThe 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.\n\nInterestingly a White/Asian applicant only gets some benefit from not specifying their race, likely because only White/Asian applicants don't.\n\nhttps://i.poastcdn.org/ce0eb5b09c128b535782627f67faeb81723ef247a95a2663606768e91c93fa24.png",
"sig": "459f347d4b3f1a0debf90fbcfd81e76fb0ec452366d82d9ff85490492ce58d347bab9de75b58c928d5746ea392096635ef74f6fec226bb9c92d4d2699fbac367"
}