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
"Your whole case against the Public Policy Gang on the teen job disappearances is going to fall apart," the voice on the other end of the line said. "How soon can you come to my office?"
"As soon as you want," the Economic Detective replied. It was, after all, the Paymaster. The man behind the money. All of it. Some say he's more powerful than the President. And now he had the Economic Detective's full attention.
"Good. I'll expect you shortly."
That's something that doesn't happen every day. If the man responsible for keeping the cash flowing through the economy is paying attention, the stakes must be pretty big.
The Paymaster's office resembles a bank. Classic architecture, complete with massive columns, elegant appointments, solid construction and armed guards. Everything is aimed at projecting an air of confidence, stability and control. The Paymaster fits his office, or rather, tries to fit. It doesn't always work.
"I've been following your case with interest," the Paymaster said. "There's a pretty big hole in your analysis that the Policy Gang could use to avoid responsibility."
"How do you mean?" the Economic Detective asked. "We've got their motive, we know how they pulled it off and the timing all fits. Hell, they even brag about what they did in jacking up the federal minimum wage. They're definitely the ones behind all those teen jobs going missing."
"Perhaps they are," the Paymaster evaluated. "The problem you face is showing that what they did, did in fact cause those jobs to vanish. Right now, all your case shows is that those job losses are correlated with the gang's activities. And we all know that correlation does not imply causation. Even freaks know that.
"Right now, you've shown that those Age 16 to 19 have had hundreds of thousands of job opportunities disappear, but that could be any job, paying anywhere from minimum wage on up to whatever Hannah Montana might be making these days.
"To really prove your case, you'll need to demonstrate that the jobs most affected by the change in the minimum wage are in fact the ones being lost. You need to show that it is the minimum wage jobs held by teens that are disappearing to prove causation. You have a lot of work left to do. "
And with that, the Economic Detective was back to work. But where to start?
Economic investigations are a lot like mining for gold. You have to sift through tons of crushed rocks in hopes of finding a single gold nugget. But if you can find that one, you might be able to find the vein of ore it came from and mine for more. The first nugget found in this case lay in a bed of revised data from the Bureau of Labor Statistics. Could the vein be nearby?
The Economic Detective hit pay dirt. The Data Jocks at the BLS put together a study every year on the characteristics of minimum wage workers. In it, they break out who makes the federal minimum wage or less each year. 2006 and 2007 were no different. We pulled the appropriate numbers from the reports:
Characteristics of Minimum Wage Workers | |||
---|---|---|---|
Year | Age 16-19 | Age 20+ | Total |
2006 | 436,000 (25.77%) | 1,256,000 (74.23%) | 1,692,000 (100.00%) |
2007 | 373,000 (21.57%) | 1,356,000 (78.43%) | 1,729,000 (100.00%) |
Change | -63,000 | 100,000 | 37,000 |
From these numbers, it seemed that just 63,000 of the 245,500 jobs we knew had been lost for teen between 2006 and 2007 were minimum wage earning jobs. But something about these numbers didn't sit right. The Economic Detective kept digging, when suddenly he had a flash of insight.
The reports put together by the BLS' Data Jocks skimmed over the change in the minimum wage between 2006 and 2007. The report states that it's counting the number of people earning the minimum wage or less. It doesn't clearly identify what that minimum wage is, except in footnotes. But if the minimum wage changes from one year to the next, that invalidates comparisons between those years. In effect, the Economic Detective had only compared is the number of people making $5.15 per hour or less in 2006 with the number of people making $5.85 per hour or less in 2007.
And that's what didn't sit right in the numbers. Out of a population of over 300 million, with around 145 million people working, did it really make sense that the total number of people counted as earning the minimum wage would only go up by 37,000 people, from 1,692,000 in 2006 to 1,729,000 in 2007?
The right comparison would be between the number of people making $5.85 or less in 2006 and the number of people making $5.85 or less in 2007. But how many people were making $5.85 or less in 2006?
To find out, we turned to an old case, where we had worked out how many people there were earning any given hourly wage in the U.S. Although built using data from 2005, that same tool should provide a fairly accurate estimate of how many people there were making $5.85 or less in 2006.
Using the tool, we first used the data we had for the level of the federal minimum wage of $5.15 per hour in 2006 to see what kind of error there might be, before estimating the number of people making $5.85 per hour. The table below shows our results:
Estimated vs Actual Number of Hourly Wage Earners in 2006 | |||
---|---|---|---|
Hourly Wage | Estimated Value | Actual Value | Error (Percentage of Actual) |
$5.15 or Less | 1,698,106 | 1,692,000 | +6,106 (0.36%) |
$5.85 or Less | 2,681,439 | Not Available | Unknown |
Given what we know of the distribution of hourly wages in the U.S., that figure of 2,681,439 makes a lot more sense. To get to the number of teens earning $5.85 or less in 2006, we'll need to multiply this figure by their percentage representation in the workforce. Here, we'll split the difference between the percentages we found for minimum wage earning teens in 2006 (25.77%) and 2007 (21.57%) and use 23.67%, since we don't know the exact proportion of teens earning $5.85 or less in 2006. Using this approximation should put us fairly close to the actual number.
Doing that math, we would predict that there were roughly 634,717 individuals Age 16-19 earning $5.85 per hour or less in 2006. If we subtract the number of teens actually counted as earning the minimum wage or less in 2007 (373,000) from that figure, we obtain a value of 261,717, which would be the estimated number of teen jobs that disappeared for this age group between 2006 and 2007.
That would more than account for the 245,500 figure that we had found previously. We therefore find that *all* of the jobs for teens that disappeared between 2006 and 2007 were, in fact, minimum wage earning jobs. More specifically, they were positions whose hourly wage was $5.85 or less - the exact jobs directly affected by the Public Policy Gang's increase in the federal minimum wage.
And that's when the Economic Detective was startled by a final gruesome discovery. Having focused so much on the mysterious disappearance of jobs for teens in an otherwise good year for the U.S. economy, he hadn't looked beyond those numbers except in passing, but here they were now staring him right in the face. Looking at the estimated data again for 2006, there should be around 2,681,439 individuals earning an hourly wage of $5.85 or less. But in 2007, there were just 1,729,000 individuals counted as doing so.
That would put the Public Policy Gang's total job kill for their first minimum wage hiking spree in 2007 at least at 952,439, almost within spitting distance of 1 million jobs. That becomes well within spitting distance if you factor in population growth. No wonder the Paymaster was so concerned.
But for teens, the mystery had been solved. Now there was only one thing left to do in that case, so the Economic Detective did it. He closed the file.
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.