To create a frequency distribution using FREQUENCY: 1  Enter numbers that represent the bins you want to group values into. 2  Make a selection the same size as the range that contains bins, or one greater if want to include the extra item. 3  Enter the FREQUENCY function as an array formula using Control+Shift+Enter.
About 71% of us also report expenses for household operations, spending $1,581 on average (or $132 per month) for services that might include babysitting or eldercare, housecleaning or lawn mowing, laundry and dry cleaning, pest control, and home security systems.
Entertainment spending varies according to income, age and location. The average American spent $2,504 on entertainment in 2010, the U.S. Bureau of Labor Statistics reported in August 2012.Entertainment spending dropped 7 percent from 2009 as consumers tightened their belts in an uncertain economy.lthough $2,504 was the overall average Americans spent on entertainment, averages vary according to a different income brackets. According to the The 2010 Consumer Expenditure Survey from the Bureau of Labor Statistics, consumers who earned less than $50,000 spent less than $2,000 on entertainment.