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.
According to the Bureau of Labor Statistics consumer expenditure surveys, the typical household spends $7,023 each year on food, which works out to an average of $585 per month. Of that portion, about $4,015 per year (or $334.58 per month) is spent on food at home â likely the average grocery budget across the U.S.