to your HTML Add class="sortable" to any table you'd like to make sortable Click on the headers to sort Thanks to many, many people for contributions and suggestions. Licenced as X11: http://www.kryogenix.org/code/browser/licence.html This basically means: do what you want with it. */ var stIsIE = /*@cc_on!@*/false; sorttable = { init: function() { // quit if this function has already been called if (arguments.callee.done) return; // flag this function so we don't do the same thing twice arguments.callee.done = true; // kill the timer if (_timer) clearInterval(_timer); if (!document.createElement || !document.getElementsByTagName) return; sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/; forEach(document.getElementsByTagName('table'), function(table) { if (table.className.search(/\bsortable\b/) != -1) { sorttable.makeSortable(table); } }); }, makeSortable: function(table) { if (table.getElementsByTagName('thead').length == 0) { // table doesn't have a tHead. Since it should have, create one and // put the first table row in it. the = document.createElement('thead'); the.appendChild(table.rows[0]); table.insertBefore(the,table.firstChild); } // Safari doesn't support table.tHead, sigh if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0]; if (table.tHead.rows.length != 1) return; // can't cope with two header rows // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as // "total" rows, for example). This is B&R, since what you're supposed // to do is put them in a tfoot. So, if there are sortbottom rows, // for backwards compatibility, move them to tfoot (creating it if needed). sortbottomrows = []; for (var i=0; i
In June 2017, Sentier Research served notice that it would suspend its reporting of monthly median household income estimates, where its final report would present the median household income for May 2017. Here's how they signed off their final report in their long-running series:
This will be our final report in the monthly series of median household income. We can no longer afford to provide these estimates given our current level of resources. We believe, as we hope you do, that these estimates provided an important new dimension regarding the economic situation of American households as we slowly climbed out of the Great Recession. The story continues but we must move on. Our hope is that someone will be able to continue this work. Should you or someone you know be interested please contact us.
Today, Political Calculations is ready to step in and fill the gap left behind by the original work of Sentier Research. We've developed an alternative method of estimating each month's median household income, which is based upon the monthly population and aggregate personal wage and salary income data reported by the U.S. Bureau of Economic Analysis.
We use that data to calculate the U.S.' Wage and Salary Income per Capita for each month. In the following chart, we show the results of that math for each month from January 1999 through May 2017, along with the entire series of monthly median household income estimates provided by Sentier Research for each month from January 2000 through May 2017.
In looking at this chart, we realized that changes in the level of the Wage and Salary Income per Capita appeared to lead changes in the Median Household Income figures reported by Sentier Research. It occurred to us that we might see the data sync-up better if we calculated the trailing year average of the Wage and Salary Income per Capita figures, which would also smooth out some of the noisy variation in that data. The following chart shows our results for doing just that math, where we've shown the trailing year average Wage and Salary Income per Capita data from January 2000 through May 2017, which already appears to better match up with the available data that we have for the unchanged Median Household Income estimates.
The next chart reveals the correlation that we discovered by plotting the Median Household Income data against the Trailing Year Average Wage and Salary per Capita.
That large concentration of points that you see in the center of the linear trend is the rise and fall of incomes during the years leading up to, continuing through, and extending after the official period of the Great Recession, mainly between January 2006 and January 2011.
As linear regression analysis goes, what we see in the chart represents an outstanding result right out of the gate. So much so, that we've built a tool to do the indicated math. The default data in the following tool applies for June 2017 (if you're reading this article on a site that has republished our RSS news feed, please click through to our site to access a working version of the tool).
Our median household income estimate for June 2017 is $58,257. This figure is slightly higher than the estimate of $58,184 that our regression analysis indicates for May 2017. After accounting from month-over-month inflation, as measured by the Consumer Price Index, we find that there really hasn't been much of a significant change.
That May 2017 figure compares with Sentier's estimate for May 2017 of $59,345, which is about 2% higher than the value that we obtained with our method. Speaking of which, we found that 70% of Sentier's reported data for January 2000 through May 2017 falls within one standard deviation of our regression model trend, 96% is within two standard deviations, and all data points fall within three standard deviations. That pattern is consistent with the residual data following a standard normal, bell-curve type Gaussian distribution.
What that all means is that we can successfully estimate the Median Household Income figure that Sentier Research would have found using their methods with a relatively low margin of error, where our linear regression-derived estimate will almost always fall within 3% of the results of Sentier Research's median household income estimate, and within 1% just over two-thirds of the time. When you consider things like sampling errors and other statistical factors like compositional changes within U.S. households over time that would affect the accuracy of Sentier's income estimates, our results will very much be in the right ballpark.
If someone else picks up Sentier's mantle and methodology for generating monthly median household income estimates, we'll be happy to feature their work! Until then, we're happy to fill in the gap left behind by Sentier's exit from producing their median household income estimates, and in fact, because we've made a tool to do our math directly available to you, if the data is available, you don't even need to wait for us or anyone else to generate it. We just ask that you provide a link back to the original post or provide an appropriate citation when you write up your results so that others can take advantage of our tool.
U.S. Bureau of Economic Analysis. Table 2.6. Personal Income and Its Disposition, Monthly, Personal Income and Outlays, Not Seasonally Adjusted, Monthly, Middle of Month. Population. [Online Database (via Federal Reserve Economic Data)]. Last Updated: 1 August 2017. Accessed: 1 August 2017.
U.S. Bureau of Economic Analysis. Table 2.6. Personal Income and Its Disposition, Monthly, Personal Income and Outlays, Not Seasonally Adjusted, Monthly, Middle of Month. Compensation of Employees, Received: Wage and Salary Disbursements. [Online Database (via Federal Reserve Economic Data)]. Last Updated: 1 August 2017. Accessed: 1 August 2017.
Sentier Research. Household Income Trends: January 2000 through May 2017. [Excel Spreadsheet with Nominal Median Household Incomes for January 2000 through January 2013 courtesy of Doug Short]. [PDF Document]. Accessed 22 June 2017. [Note: We've converted all data to be in terms of current (nominal) U.S. dollars.]