Federal Reserve Economic Data

The FRED® Blog

Posts tagged with: "UNRATE"

View this series on FRED

Time aggregation in FRED

In many instances, statistics are collected at a higher frequency than a user requires. In the example here, the unemployment rate is collected monthly, but we often have other labor market data collected annually. The question here is how to aggregate the high-frequency data into a lower-frequency statistic. In FRED, we have three options: average, sum, or end of period. In the graph, we compare annual unemployment data taking either the average over the year or the end-of-period observation. The choice of whether to use seasonal adjustment doesn’t affect the average. By definition, seasonal adjustment implies that December, the last month of the year, does not have a systematically different unemployment rate from any other month. However, averaging or summing will systematically give lower measures of variation than the end-of-period observation. The reason is simple, even without too much formal math: Suppose every month our observation is the annual number plus some monthly “noise” term. Either summing or taking the average, we essentially allow these monthly variations to cancel each other out. Taking an observation from the end of period includes all of the month-specific variation. In the graph, we can see that the red line, which takes annual unemployment as the final month’s observation, is more volatile. In fact, from 1979-2014, its coefficient of variation is 25.56%; the blue line, which takes the average, has a coefficient of variation of 24.86%.

How this graph was created: Search for “unemployment” and select the seasonally adjusted civilian unemployment rate. Using the pull-down menu, change “Frequency” to “Annual.” The default “Aggregation Method” is “Average,” and we will keep that. Then, “Add Data Series” and again search for “unemployment.” Add a new series using “unrate,” the same data as last time. Again, change it to an annual frequency. But this time, change the aggregation method to “End of Period.”

Suggested by David Wiczer.

View on FRED, series used in this post: UNRATE

Wage stickiness

Unemployment has been a fixture in the news since 2008, but relatively little has been said about wages. So how have wages changed as the U.S. has weathered the Great Recession and the spike in unemployment? Most people would expect that wages have decreased, but data in FRED offer a different perspective. The graph above shows two time series from the Bureau of Labor Statistics: unemployment (red line) and private industry wages and salaries (green line) from the employment cost index. Note that even when unemployment rapidly doubled, the green wages line continued to rise (albeit at a reduced rate). In other words, as the economy contracted and employers sought to cut costs, they almost exclusively opted to lay off workers rather than negotiate for lower wages. This phenomenon is known as downward nominal wage rigidity: During macroeconomic shocks such as recessions, wages remain “sticky.” Of course, it’s possible that inflation is cutting real wages even if nominal wages aren’t changing. However, when we adjust the wages data for inflation in the graph below (blue line), the pattern remains similar. Although real wages posted a slight decline several years after the recession hit, it pales in comparison to six years of elevated unemployment.

How these graphs were created: For the first graph, search for and add the unemployment series (left y-axis) and the total wages series (right y-axis). For the second graph, add the wages series (a) and the consumer price index (b) as parts of a single data series. Do this using the “Modify Existing Series” option within “Add Data Series.” Set the units for both (a) and (b) to “Index” with the observation date equal to 2007-11-01. Then, in the “Create your own data transformation” option, enter “(a/b)*100” in the formula box and apply the transformation. For the trend line, choose “Trend Line” under “Add Data Series” and set the start date to 2007-10-01. Set both the start and end values to 100.

Suggested by Ian Tarr.

View on FRED, series used in this post: CPALTT01USM661S, ECIWAG, UNRATE

Measuring misery

The mandate of the Federal Reserve calls for stable prices and maximum employment. One way to assess these conditions is to look at the consumer price index inflation rate and the unemployment rate, respectively. It has even become somewhat popular to look at the sum of these two measures, the so-called “misery index,” shown here. Now, you may not consider the “misery” of inflation to be entirely equivalent to the “misery” of unemployment. So, if you believe that a multiplier should apply to one of these two measures, you can use a custom formula to transform the series in the FRED graph.

How this graph was created: On the FRED homepage, you’ll see CPI (among other popular series): Click on that to open the related FRED graph. Add the series “Civilian Unemployment Rate,” making sure to use the “Modify existing data series” option. Then change the units for the first series to “Percent Change from Year Ago” and create your own data transformation with formula a+b or any other formula you find appropriate.

Suggested by Christian Zimmermann

View on FRED, series used in this post: CPIAUCSL, UNRATE


Back to Top