Federal Reserve Economic Data

The FRED® Blog

Adjusting dollar figures for inflation with FRED

Customize the data by choosing a new reference period

FRED includes consumer price index data from the US Bureau of Labor Statistics. FRED data tools make it easy to use these price data to calculate the dollar value of figures measured at constant prices—a process known as adjusting for inflation.

The FRED Blog frequently adjusts for inflation when describing prices, whether it’s gasoline prices, stock prices, or foreign exchange (just to name a few data series).

The FRED graph above shows two versions of monthly advance retail sales of retail trade and food services, reported by the US Census. The blue line shows the dollar figures unadjusted for inflation, and the red line shows the dollar figures adjusted for inflation with the aforementioned consumer price index (CPI). The CPI currently uses the years 1982-1984 as the reference period, so you can think of the data shown by the red line as retail sale figures measured in 1982-1984 prices.

FRED makes it easy to customize the reference period to adjust dollar figures for inflation. So, read on!

The second FRED graph above shows the same advance retail sales series as the first graph, but adds two alternatives using customized reference periods: the start of the 2001 recession (the dashed-dotted red line) and the start of the 2020 recession (the dashed red line). The steps for creating that graph are listed below.

A benefit of customizing the reference period, by choosing a more-recent date, is to facilitate the visual comparison between the inflation-adjusted and unadjusted data. And, given that the choice of reference period does not impact the calculation of the rate of growth of inflation-adjusted data, you can be confident using those units to tell the real story behind the numbers.

How the graphs were created: First graph: Search FRED for and select “Advance Real Retail and Food Services Sales.” Use the “Edit Graph” panel to select the “Add Line” tab and search for and add “Advance Retail Sales: Retail Trade and Food Services.” Second graph: Add another line for “Advance Retail Sales: Retail Trade and Food Services” and customize the data by searching for “Consumer Price Index for All Urban Consumers: All Items in U.S. City Average.” Don’t forget to click “Add.” Next, type the formula (a/b)*100 and click “Apply.” Edit the “(b)” series in Line 2 by changing the units to “Index (Scale value to 100 for chosen date)” and selecting a date of your choice. Finally, repeat these last steps with a new line, searching for “Advance Retail Sales: Retail Trade and Food Services” and selecting a different date. You  can also use the “Format” tab to play with the color and style of the lines.

Suggested by Diego Mendez-Carbajo.

Differences in homeownership and rental rates by race

The FRED Blog has used data on homeownership from the US Census to discuss regional and racial differences in the fraction of households who own a home. Today, we use data from the US Bureau of Labor Statistics to explore the same topic from a different perspective: We compare the proportion of homeowners to renters across racial groups.

The FRED graph above shows data from the Consumer Expenditure Surveys on the fraction of households who own a home and the fraction of households who rent a home. Households are classified in racial groups as either “White and All Other Races, Not Including Black or African American” (blue line) or “Black or African American” (red line).* We calculate the proportion of homeowner households to renter households and include a custom horizontal line with a value of “1” (dashed black line) to make the analysis easier.

On average, there are at least two non-Black or African American households that own a home for every non-Black or African American household that rents a home. By contrast, the number of Black or African American households that own a home is consistently smaller than the number of Black or African American households that rent a home.

Why is there a racial gap in homeownership? There are multiple reasons. The US Department of the Treasury’s Office of Economic Policy lists past government policies, discrimination in the private mortgage market, and differences in economic well-being. On this last reason, the Board of Governors of the Federal Reserve System’s Report on the Economic Well-Being of U.S. Households in 2023 emphasizes the role of income in making homeownership accessible. The report also shows recent data on homeownership/renting status according to age and disability status.

Although there are many reasons behind the racial gap in homeownership, income gaps between population groups likely play a key role in it.

* Data on “Asian” households, by themselves, are shown here because the BLS dataset includes them in the “White and All Other Races, Not Including Black or African American” group.

How this graph was created: Search FRED for the series “Consumer Unit Characteristics: Percent Homeowner by Race: White and All Other Races, Not Including Black or African American.” Click “Edit Graph” and use the “Edit Line” tab to customize the data by adding the data series “Consumer Unit Characteristics: Percent Renter by Race: White and All Other Races, Not Including Black or African American.” Next, type the formula a/b and click “Apply.” Use the “Add Line” tab to search for and add the homeownership data series for “Black or African American” households. Repeat the data customization process described earlier to calculate the ratio of homeowners to renters for “Black or African American” households. Last, use the “Add Line” tab to add a custom line with start and end values equal to “1.”

Suggested by Asise Bhinder and Diego Mendez-Carbajo.

Immigrant talent in the US labor force

The FRED Blog has discussed the migration of persons in and out of the US and some of the economic impacts of short-term disruptions to these flows. Today, we discuss the labor market experiences of immigrants to the US by highlighting recent research from the St. Louis Fed.

The FRED graph above shows the employment-to-population ratios for native-born (blue lines) and foreign-born (red lines) men and women (solid and dashed lines, respectively). The employment-to-population ratio is reported by the US Bureau of Labor Statistics (BLS); as the name suggests, it represents the fraction of each population group that’s employed.

Between 2007 and 2024, foreign-born men were employed in larger proportions than native-born men. That difference has steadily ranged, on average, between 15% and 17%. During the same period, native-born and foreign-born women were employed in very similar proportions. That employment-to-population gap has been steadily declining. Lastly, the broad outline of gender gaps in labor market outcomes are also visible in the BLS data shown above.

Recent research from Serdar Birinci and Fernando Leibovici at the St. Louis Fed and Kurt See at the Bank of Canada helps tell the story behind the numbers.

Their analysis finds that recent immigrants are more likely to be without a job, as well as employed in occupations with low pay, than more established immigrants. They also find that English proficiency and country of origin impact those labor market outcomes. In-depth analysis of the data also reveals that native- and foreign-born women engage very differently in non-market occupations, such as unpaid household work.

For more about this and other research, visit the website of the Research Division of the Federal Reserve Bank of St Louis, which offers an array of economic analysis and expertise provided by our staff.

How this graph was created: In FRED, search for and select “Employment-Population Ratio – Native Born, Men.” From the “Edit Graph” panel, use the “Add Line” tab to add the other three series: “Employment-Population Ratio – Foreign Born, Men,” “Employment-Population Ratio – Native Born, Women,” and “Employment-Population Ratio – Foreign Born, Women.” Lastly, use the “Format” tab to change the lines color and style.

Suggested by Hannah Edwards and Diego Mendez-Carbajo.



Subscribe to the FRED newsletter


Follow us

Back to Top