Skip to content

Math 241 – Lecture Notes 3/8/2011

March 12, 2011

Read more…

Math 241 – Homework #1

March 11, 2011

Read more…

Increasing Inaccuracy of State Revenue Estimates

March 9, 2011

Every year, every state projects upcoming state tax revenues. It matters a lot. These estimates are used by legislators, technocrats, and the governor to determine spending for schools, health care, and agency or program in government. Sometimes, when states are on a biannual budget, spending must determine spending for two years. Imagine trying to estimate your living expenditures for two years. The Pew Center on the States and Rockefeller Institute of Government released a report on this issue.

Even though recessions are becoming less frequent (e.g., great moderation), state revenue estimates are increasing inaccurate. I have covered Iowa revenue estimates before and it turns out the same pattern is being exhibited nationwide:

In 2009, the median error among states was an overestimate of 10.2 percent. That equated to an unexpected revenue shortfall of nearly $50 billion in person income, corporate income and sales tax revenues. In a year when state policy makers faced $63 billion in midyear budget gaps–coming atop $47 billion they had already closed when crafting their budgets–this misestimate posed a significant challenge.

The similar pattern between Iowa and the nation is remarkable. Here is a recent graph that shows the relationship between Iowa revenue estimates and actual revenues for December:

State net revenue in millions

Project and actual are the same curves, but project is a bit lagged. A similar graph for all states shows a similar pattern:

Pew Center on the States/Nelson A. Rockefeller Institute for Government, Cracks in the Crystal Ball, Exhibit 4

Again, revenues are overestimated at the beginning of a recession, underestimated during recoveries.

Pew also suggests these estimates are becoming more inaccurate:

During the 1990-92 revenue crisis, 25 percent of all state forecasts fell short by 5 percent or more. During the 2001-03 downturn, 45 percent of all state forecasts were off by 5 percent or more. In 2009, 70 percent of all forecasts overestimated revenues by 5 percent or more

Much of the problem stems from a basic statistical issue, it’s rare that the economy turns. Since 1991, the economy has only made six “turns”–we’ve come out of three recessions and recovered from three.* Even very sophisticated statistical models will likely miss these “turns”. So what can we do to ameliorate these difficulties?

The report highlights four promising approaches:

  1. Analyzing Errors and refining assumptions
  2. Making frequent estimates
  3. Ensuring independence from the political process
  4. Adding expertise

Each are a good suggestion. I really can’t fathom providing accurate estimates without #3 and #4 being met.

A fifth and sixth recommendation should be:

  • Incorporating estimated errors
  • Improving recent economic data

My fifth recommendation is somewhat technical, but important. To illustrate the importance, consider projecting a path of a hurricane. Below is an example of such projections. The projections show the hurricane will hit New Orleans (this is 2008′s Hurricane Gustav). But notice the margin of error around the projections? These are the estimated errors, and they are very important to forecasting.

Projected path of Hurricane Gustav, via watercrunch.com

There are equally important to budget forecasts. If state revenue estimates are truly becoming more inaccurate, then that means these errors are becoming more important. If revenue projections aren’t an exact science, then perhaps we should better present the data as an inexact science. Gustav? If you recall, didn’t land in New Orleans, but in nearby Cocodrie–within the range of the hurricane’s predicted path.

My sixth recommendation is also important. There are tremendous resources at the federal level that permit fairly accurate projections. As economies change, we may need to look at different sets of data to forecast future economic fluctuations. Some recent innovative practices is using road tolls to “nowcast” the business cycle.

Statistics: Final

March 2, 2011
tags:

This final is due Sunday, March 6 by 11:00pm. Finals must be submitted via email to the instructor. Submissions must include Excel workbooks, SPSS output files, and a seperate Word document which provides the answers. See below the “more…” link for the full exam.

Read more…

Majoring in “Universe”

February 21, 2011
tags: ,

Go to the page to see the real alt-text

…in today’s xkcd–amusing as always. Since I originate from both backgrounds (computers, economics & comparative politics) I should know a little more. Problem is, the Europeans don’t name failed summits. Maastricht Treaty gets a name because it was very successful. Nevertheless, my best try:

  • Every other EU summit on establishing a European Union constitution in the 00′s.

And that’s all I can remember (unless you also count the failed Doha Round, but more than Europe was just involved). And no idea on microprocessor instruction set–never learned assembly code.

Finally, a paper out of this project

February 17, 2011

Found here. It is based on the visualizing transitions into the workforce project that I have been working on and you can see to the left.

Visualizing Tuition & Fees

February 11, 2011

The Chronicle of Higher Education has put together an interactive chart showing tuition and fees at Iowa community colleges. Play through the timeline and you can see tuition and fees becoming a larger share of revenue for the 15 colleges, while state funding declined. There are a couple of notes along the way to highlight majors shifts.

We’ve tried a few other methods to display this same data at the Iowa Department of Education. Below is a the standard image that shows up in our Tuition and Fees Report and Condition of Iowa’s Community Colleges. We use a similar, static plot, with one major difference is we plot on dollar amounts, not percentage.

I’ve previously highlighted a Tufte scatterplot of the same data. Below we use shading to represent the approximate decade of data. The lighest points represent the 1970s, which grows darker until the black points represent the 2000s and the red point is the most recent data:

I like the interactive nature of the Chronicle data, but I don’t like that you cannot see all of the data without having to scroll. I’m not sure why the Chronicle chose to especially highlight Iowa data–it was accompanied by an article about funding in general which talked with a lot of Iowa leaders–but it is always nice to see someone else using our data.

Updated Chapter

February 10, 2011

My chapter for the Handbook for Institutional Research, “Workforce and Technical Skill Education and Its Assessment” has been substantially updated. The new draft is available here. The book is expected to be published this summer.

Statistics Class Update

January 31, 2011

Class-

Those who attended Tuesday, 1/25, may have recalled that I ended class because I was not feeling well. That illness ultimately required hospitalization that led to the cancellation of Thursday’s, 1/27, class. Over the weekend I’ve undergone an operation which will require me to cancel this Tuesday’s, 2/1, class.

I am continuing to recover this week, but I am uncertain about the remaining classes this week. Nevertheless, we will be able to finish the semester. But in the meantime, I am behind on returning homework and responding to emails. I appreciate your patience as I try to get back on my feet this week.

Statistics: Lecture Notes 1/26/2011

January 26, 2011

Link to the spreadsheet from class below. Images below the fold.

Survey of Basic Classroom Data – Standardizing

Read more…

Follow

Get every new post delivered to your Inbox.

Join 41 other followers