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 |
