8 Comments
User's avatar
Kaitlin Solimine's avatar

Thanks, as always, for such an important Substack. Do you have any similar data on socioeconomic class/diversity? Further, do you have this similar data set for private schools in SF? Thanks.

Don's avatar

How can I get these data in an excel spreadsheet?

Paul Gardiner's avatar

If you send me your email, I’ll share the Google sheet with you

Don's avatar

By the way, I could not convert it to an Excel spreadsheet.

Madeline Aubry's avatar

That is alright. A google sheet would suffice. Thanks!

Madeline Aubry's avatar

Hi Paul, could you share the data with me, as well. I am a former SFUSD student and am conducting a research project on diversity within SFUSD. my email is: maubry@oxy.edu

Thank you so much.

Madeline

Don's avatar

Thanks. Looking for the list of schools with the divergence index. I assume I can convert Google to Excel.

What do you think of this index as a definition of diversity?

denochson@aol.com

Paul Gardiner's avatar

It fulfilled the criteria I had, which were (a) measures how much an observed distribution diverges from some expected distribution (b) had been used by other researchers so I can't be accused of using some arbitrary method to get results to my liking. The one thing I dislike about it is hard to explain the individual contributions to a calculation. If the expected values for groups A, B, and C were 50%, 30% and 20% and the observed values were 30%, 40%, and 30%, the "contribution" of A to the overall divergence will be negative. I think it would be easier to explain if all the contributions were positive as they are in any sort of sum of the square of the deviation approach.

I've shared the spreadsheet with you. The calculation is sensitive to the chosen benchmark. I did multiple versions of the calculation, one comparing to the SF under 18 population, one to the SFUSD elementary and middle school population etc.