Statistical formulas documentation
From mtab wikisupport
mTAB Median Calculation from Income Brackets
| Approximate Annual HH Income | |
| Median | 71,180 |
| Unweighted Sample Total Count | 10,811 |
| Approximate Annual HH Income | Weighted Response (1) Accumulated Response |
||
| Less than $15,000 || width="150"|11,714 || 11,714 |- | $15,000 - $24,999 || 46,054 || 57, 768 |- | $25,000 - $34,999 || 83,965 || 141,733 |- | $35,000 - $44,999 || 102,093 || 243,826 |- | $45,000 - $59,999 || 155,721 || '''399,546''' |- | $60,000 - $74,999 || 161,435 || '''560,981''' <--''Median will fall here'' (3) |- | $75,000 - $99,999 || 193,540 || 754,521 |- | $100,000 - $124,999 || 134,706 || 889,227 |- | $125,000 - $149,999 || 59,748 || 948,975 |- | $150,000 - $199,999 || 41,971 || 990,946 |- | $200,000 - $249,999 || 16,391 || 1,007,337 |- | $250,000 or More | 32,409 | 1,039,746 | |
| Weighted Subset Total Count | 1,039,746 | ||
| Weighted Sample Total Count | 1,255,411 | ||
| (1) | Calculated Accumulated Weighted Response | |
| (2) | Divide total (1,039,746) by 2=519,873 | 519,873 |
| (3) | Find first value in Accumulated Response column that is greater than step 2 value | |
| The median will fall between the $60,000-$74,999 bracket | ||
| (4) | Step 2 amount (519,873) MINUS preceding break accumulated response 399,546 = | 120,327 |
| (5) | Acc. Response where Meidan will fall 560,981 MINUS preceding break 399,546 = | 161,435 |
| (6) | Step 4 Divided by Step 5 | 0.74536 |
| (7) | Multiply Step 6 by the range 14,999 ($60,000-$75,999) | 11180 |
| (8) | Add Step 7 to bottom of range $60,000 | 71,180 |
