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.ccording to the Consumer Expenditure Survey, entertainment spending also varied according to age. On the low end, people 25 and younger had entertainment budgets that averaged $1,221, and consumers 75 and older spent an average of $1,334. The biggest entertainment spenders were between 35 and 54, who averaged $3,050.