November 19, 2009

How much money does the average American earning \$40,000 a year spend on housing-related expenses? What percentage of the total spending of a typical 58 year old American goes to buy food and alcoholic beverages? And how much does the average American consumer unit (the personable phrase the data jocks at the BLS use to describe the people who spend money in the U.S.) put toward their retirement savings?

Even though the government collects all this data each year in the Consumer Expenditure Survey (CES), the answers to these questions aren't necessarily easy to extract. The government sorts the individuals and households who make up the so-called consumer units by what age range they fall into, or by what income range they earn, or by education level or a whole bunch of other basic categories, but they don't narrow the data down enough to isolate the people between Age 25 and 34 who earn between \$30,000 and \$39,000 before taxes, for example. Instead, we get a picture that includes everyone who falls in a given age range or whose annual income falls inside a given range, and that's as close as we can get from the data that's made freely available.

Until now. We've mined the Consumer Expenditure Survey and identified the kinds of spending that are driven by income and that are driven by age. We did this by first identifying where we saw the widest spreads in the datapoints for either income or age-based variation in the CES, and then by using the data regression tools at Zunzun to create a mathematical model for each major expenditure item.

We've put the outcome of our analysis at your fingertips in the tool below, in which you can simply enter the age of the "reference person" (another BLS term of endearment) and their annual before-tax income to calculate how much such an individual spends on any of the major expenditure categories we've listed. We'll also determine what percentage of the total spending that each category represents.

Age and Income Data
Input Data Values
Age
Annual Income

Income-Driven Expenditures
Calculated Results Average Annual Expenditures Percentage of Total
Housing
Transportation
Food and Alcoholic Beverages
Personal Taxes
Apparel and Services
All Other Expenditures
Age-Driven Expenditures
Calculated Results Average Annual Expenditures Percentage of Total
Retirement Savings
Health Care
Cash Contributions
Education
Total Expenditures
Calculated Results Average Annual Expenditures Percentage of Total
Total Expenditures

Each of the categories listed above correspond to the top line data for each presented in the 2008 CES data tables from which we obtained the data used in our regression analysis, except as follows:

1. Food and Alcoholic Beverages. Here we combined the top line expenditures from the 2008 CES income table for both Food and Alcoholic Beverages.

2. Personal Taxes. We added the average amount of Federal, State and Local, and Other taxes as taken from the 2008 CES income table, along with our estimate of the average Social Security taxes paid by each age group. We determined this latter figure by multiplying the indicated annual income provided by Wages and Salaries data by 6.2%. While there is a cap on the amount of income subject to Social Security taxes, we neglected to consider it for this application because the income ranges that would be affected are in part produced by combining the incomes earned by the members of the average CES' consumer unit for each income level. As a result, it would be very easy for a consumer unit with two incomes to be above that individual income threshold without being affected by Social Security's income cap. Finally, we omitted the effect of the 2008 stimulus tax credit upon personal income taxes paid altogether, since this represents a factor unique to 2008.

3. Entertainment and Reading. Here, we combined the top line expenditures for both Entertainment and Reading that we obtained from the 2008 CES income table.

4. Retirement Savings. This is a hybrid of both income-driven and age-driven spending patterns. For this category, we started with the top line data for Personal Insurance and Pension expenditures that we found in the 2008 CES income table and subtracted the expenditures for Life and Other Personal Insurance from it, along with our estimate of Social Security taxes, which we described above. Then, using the data we obtained in the 2008 CES age table, we accounted for the draw-down in retirement savings that we observed corresponds to approximately when the reference person in a consumer unit reaches the ages where they no longer save for retirement, but instead begin taking it (that transition begins approximately at 59.5 years of age.)

5. All Other Expenditures. For this category, we combined the expenditures for Life and Other Personal Insurance with the top line expenditures that we found in the 2008 CES income table for Personal Care Products and Services, Tobacco Products and Smoking Supplies and also Miscellaneous expenditures.

What can you do with this information? Well, if you were ever curious to see how your consumer unit's spending compares to that of the average American consumer unit, at least of similar age and income, our tool's output will show you what that average level of spending is!

### Data Sources

Bureau of Labor Statistics. "Table 3. Age of reference person: Average annual expenditures and characteristics, Consumer Expenditure Survey 2008". ftp://ftp.bls.gov/pub/special.requests/ce/standard/2008/age.txt. Accessed 16 November 2009.

Bureau of Labor Statistics. "Table 2. Income before taxes: Average annual expenditures and characteristics, Consumer Expenditure Survey, 2008". ftp://ftp.bls.gov/pub/special.requests/ce/standard/2008/income.txt. Accessed 16 November 2009.

Bureau of Labor Statistics. "Table 2301. Higher income before taxes: Average annual expenditures and characteristics, Consumer Expenditure Survey, 2008". ftp://ftp.bls.gov/pub/special.requests/ce/standard/2008/higherincome.txt. Accessed 16 November 2009.

Labels: , , ,

Unexpectedly Intriguing!

is good for you

Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:

ironman at politicalcalculations.com

Recent Posts

What Drives American Spending? (Part 2)

What Drives American Spending? (Part 1)

The Fallacy of Linear Thinking

On the Moneyed Midways - November 13, 2009

Estimating the Value of Stock Options

It's Not an Accident

Locking on the Future Target

The Teen Job Scene in October 2009

On the Moneyed Midways - November 6, 2009

The Link Between Intangible Investments and GDP

Most Popular Posts
Quick Index

U.S. GDP Temperature Gauge

Political Calculations' U.S. GDP Temperature Gauge provides a means to quickly evaluate the growth rate of the U.S. economy against the backdrop of how the economy has performed since 1980, with the "temperature" color spectrum ranging from a recessionary "cold" (purple) through an expansionary "hot" (red).

The GDP Temperature Gauge presents both the annualized GDP growth rate as reported by the U.S. Bureau of Economic Analysis reports for a one-quarter period and also as averaged over a two quarter period, which smooths out the volatility seen in the one-quarter data and provides a better indication of the relative strength of the U.S. economy over time.

Site Data

Visitors since December 6, 2004:

#### JavaScript

The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.

#### Other Cool Resources

ZunZun - Exceptional regression analysis tool.
Wolfram Integrator - Solve integrals. Do calculus!
Create a Graph - Easy-to-use basic graph-making tool.
Many Eyes - Data visualization extraordinaire!
Wolfram Alpha - Computational knowledge engine.
Khan Academy - Math & science video mini-lectures!
Picasion - Animate images.

Archives
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
July 2008
August 2008
September 2008
October 2008
November 2008
December 2008
January 2009
February 2009
March 2009
April 2009
May 2009
June 2009
July 2009
August 2009
September 2009
October 2009
November 2009
December 2009
January 2010
February 2010
March 2010
April 2010
May 2010
June 2010
July 2010
August 2010
September 2010
October 2010
November 2010
December 2010
January 2011
February 2011
March 2011
April 2011
May 2011
June 2011
July 2011
August 2011
September 2011
October 2011
November 2011
December 2011
January 2012
February 2012
March 2012
April 2012
May 2012
June 2012
July 2012
August 2012
September 2012
October 2012
November 2012
December 2012
January 2013
February 2013
March 2013
April 2013
May 2013