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.
Photo: Reuters. Americans spent an average of almost $94 a day last month in stores, restaurants, gas stations and online. That's a lot of walking-around money, and it's higher than the $89 per day spent in July 2013, but lower than the six-year high of $98 per day recorded in May.