Recreating Laffer's unemployment benefits payout vs. unemployment rate chart but not his ridiculous conclusions

Howard points to an excellent refutation of the ridiculous claims by Laffer that unemployment benefits drive unemployment. The chart from the opinion page clearly shows a lag of 10 months to a year of the peak in benefits payouts vs. unemployment rate peaks. Perhaps it is unemployment which drives unemployment benefits.

One thing that drives me nuts on these charts is when the presenter doesn't cite the data. I would make it a requirement that for any charts like these that you must publish your work and the data you used, but as a minimum the presenter should cite the references. Laffer cites as his source Laffer associates, but I guarantee you they didn't generate the data. References for the data are given below. I have recreated the chart below (click for large size).

The unemployment rate is the straight data from the Bureau of Labor Statistics, seasonally adjusted, while the benefits paid is the average weeks on unemployment multiplied by the average weekly benefits per person and is from the Dept of Labor source below, but the key is that it needed to be adjusted to 2010 dollars. Perhaps Mr. Laffer could have included that in his description.

Once I recreated the chart and data, it is simple to see that the peaks in the benefits paid occur from 9 to 13 months after the peak in unemployment rate. Even the most egregious examples of correlation being mistaken for causation have the cause preceding the effect, unlike here. I am sure someone even more mathematically inclined can run some sort of time series correlation with the data, now that I have provided it.

Data sources and links follow:

Unemployment statistics from the Bureau of Labor Statistics. Use this form to enter in your choices and you can get an excel file of the data. I only changed the Labor force status to Unemployed or to Unemployed rate and checked the monthly data and seasonally adjusted boxes to generate my files for actual number unemployed and rate of unemployment. You may need to adjust the years on the next page. Not used but you can get the duration of unemployment benefits using this page and checking the appropriate boxes.

Unemployment claim amounts paid can be found under the on the program statistics page, which leads to this form from the United States Department of Labor. You can uses this calculator to get the yearly adjustments for inflation. I actually used the tables from here for CF adjusted to 2007, and the calculator to adjust 2007 to 2010 (1.05).

Data to create the charts above is in this google docs spreadsheet - Unemployment statistics 1971 to 2010.