7 Comments

How can I get these data in an excel spreadsheet?

Expand full comment

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

Expand full comment

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

Expand full comment

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

Expand full comment

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

Expand full comment

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

Expand full comment

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.

Expand full comment