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.
Here are some other details from the report: Spending on communications climbed 5.1 per cent to $1,825 in 2011. In that year, the average household spent $809 on cell phone expenses, $481 on expenses related to land-line telephones and $416 on Internet access.Eight in 10 households â or 79 per cent â reported owning at least one cell phone, while 12.8 per cent reported having only a cell phone and no landline, the agency said.n that year, the average household spent $809 on cell phone expenses, $481 on expenses related to land-line telephones and $416 on Internet access.