Closed benhammondmusic closed 5 months ago
In BigQuery pct_rel_inequity = +206.7%
pct_rel_inequity = (pct_share of condition - pct_share of population) / pct_share of population
pct_share of condition = a race groups count of condition / total count of condition all races
black mm count = 186 all mm count = 505
black pct_share_mm = 186/505 = 36.8%
black lb count = 593,200 all lb count = 3,965,200
black pct_share_pop (lb) = 593,200 / 3,965,200 = 15.0%
(36.8 - 15) / 15 = +145.3% higher than expected (not of expected)
Need to do #3192 to more accurately calculate our pct_rel inequity figures
Manually Spot-Check Data