Difference between revisions of "Statistical formulas documentation"
From mtab wikisupport
| Line 9: | Line 9: | ||
| Unweighted Sample Total Count || 10,811 | | Unweighted Sample Total Count || 10,811 | ||
|} | |} | ||
| + | |||
{| | {| | ||
| Line 46: | Line 47: | ||
{| | {| | ||
|- | |- | ||
| − | | (1) || width="550"|<span style="color:red">'''Calculated Accumulated Weighted Response'''</span> | + | | <span style="color:red">(1)</span> || width="550"|<span style="color:red">'''Calculated Accumulated Weighted Response'''</span> |
|- | |- | ||
| − | | (2) || Divide total (1,039,746) by 2=519,873 || 519,873 | + | | <span style="color:red">(2)</span> || Divide total (<span style="color:blue">1,039,746</span>) by 2=<span style="color:red">519,873</span> || <span style="color:red">519,873</span> |
|- | |- | ||
| − | | (3) || Find first value in Accumulated Response column that is greater than step 2 value | + | | <span style="color:red">(3)</span> || 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 | | || 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 | + | | <span style="color:red">(4)</span> || Step 2 amount (<span style="color:red">519,873</span>) 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 | + | | <span style="color:red">(5)</span> || Acc. Response where Meidan will fall <span style="color:green">560,981</span> MINUS preceding break '''399,546''' = || 161,435 |
|- | |- | ||
| − | | (6) || Step 4 Divided by Step 5 || 0.74536 | + | | <span style="color:red">(6)</span> || Step 4 Divided by Step 5 || 0.74536 |
|- | |- | ||
| − | | (7) || Multiply Step 6 by the range 14,999 ($60,000-$75,999) || 11180 | + | | <span style="color:red">(7)</span> || 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''' | + | | <span style="color:red">(8)</span> || Add Step 7 to bottom of range $60,000 || '''71,180''' |
|} | |} | ||
Revision as of 14:07, 6 August 2013
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 |
