Answer these questions:
- present nominal dollar values over time?
- want to add inflation-adjusted values in your analysis?
We have some exciting news! Query the Enterprise Data Warehouse (EDW) to include inflation adjustment values in your analysis project.
Get It in the EDW
See inflation adjustment examples in our research expenditure dashboards in UW Profiles:
How It Works
Every month the EDW Team pulls consumer price index (CPI) data from the Bureau of Labor Statistics giving you access to this data through EDW queries. We use CPI to adjust nominal expense data for inflation.
The Math Behind It All
For an annual (fiscal year) analysis:
- Annual Average: Adjust a nominal value for inflation by first taking the average of each of the CPI values for each month in the Fiscal Year.
- Inflation Adjustment: Divide the CPI average for the period the transaction occurred (e.g. 2010) by the CPI value for the current time (e.g. 2018).