Time aggregation in FRED | FRED Blog
Skip to main content
Explore Our Apps
FRED
Tools and resources to find and use economic data worldwide
FRASER
U.S. financial, economic, and banking history
ALFRED
Vintages of economic data from specific dates in history
CASSIDI
View banking market concentrations and perform HHI analysis
Release Calendar
Tools
FRED Add-in for Excel
FRED API
FRED Mobile Apps
News
Blog
About
What is FRED
Tutorials
Digital Badges
Contact Us
My Account
Explore Our Apps
Explore Our Apps
FRED
Tools and resources to find and use economic data worldwide
FRASER
U.S. financial, economic, and banking history
ALFRED
Vintages of economic data from specific dates in history
CASSIDI
View banking market concentrations and perform HHI analysis
STL Fed Home Page
Release Calendar
Tools
FRED Add-in for Excel
FRED API
FRED Mobile Apps
News
Blog
About
What is FRED
Tutorials
Digital Badges
Contact Us
Search FRED Blog
Search for:
Recent Posts
US manufacturing employment is down, but each state has its own story
Real GDP growth by state: First quarter 2026
Primary deficits: a short history
What US assets are held overseas?
Durable goods inflation and effective tariffs
Recent St. Louis Fed research
US manufacturing employment is down, but each state has its own story
Real GDP growth by state: First quarter 2026
Primary deficits: a short history
What US assets are held overseas?
Durable goods inflation and effective tariffs
Archives
July 2026
June 2026
May 2026
April 2026
March 2026
February 2026
January 2026
December 2025
November 2025
October 2025
September 2025
August 2025
July 2025
June 2025
May 2025
April 2025
March 2025
February 2025
January 2025
December 2024
November 2024
October 2024
September 2024
August 2024
July 2024
June 2024
May 2024
April 2024
March 2024
February 2024
January 2024
December 2023
November 2023
October 2023
September 2023
August 2023
July 2023
June 2023
May 2023
April 2023
March 2023
February 2023
January 2023
December 2022
November 2022
October 2022
September 2022
August 2022
July 2022
June 2022
May 2022
April 2022
March 2022
February 2022
January 2022
December 2021
November 2021
October 2021
September 2021
August 2021
July 2021
June 2021
May 2021
April 2021
March 2021
February 2021
January 2021
December 2020
November 2020
October 2020
September 2020
August 2020
July 2020
June 2020
May 2020
April 2020
March 2020
February 2020
January 2020
December 2019
November 2019
October 2019
September 2019
August 2019
July 2019
June 2019
May 2019
April 2019
March 2019
February 2019
January 2019
December 2018
November 2018
October 2018
September 2018
August 2018
July 2018
June 2018
May 2018
April 2018
March 2018
February 2018
January 2018
December 2017
November 2017
October 2017
September 2017
August 2017
July 2017
June 2017
May 2017
April 2017
March 2017
February 2017
January 2017
December 2016
November 2016
October 2016
September 2016
August 2016
July 2016
June 2016
May 2016
April 2016
March 2016
February 2016
January 2016
December 2015
November 2015
October 2015
September 2015
August 2015
July 2015
June 2015
May 2015
April 2015
March 2015
February 2015
January 2015
December 2014
November 2014
October 2014
September 2014
August 2014
July 2014
June 2014
May 2014
April 2014
March 2014
The FRED® Blog
Time aggregation in FRED
Posted on September 28, 2015
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
Tagged UNRATE
--
Back to Top
Filter
0
Subscribe to the FRED newsletter
Subscribe
Follow us
Saint Louis Fed linkedin page
Saint Louis Fed facebook page
Saint Louis Fed X page
Saint Louis Fed YouTube page
 
Need Help?
Questions or Comments
FRED Help
Legal
Privacy Notice & Policy