Enter numbers that represent the bins you want to group values into. Make a selection the same size as the range that contains bins, or one greater if want to include the extra item. Enter the FREQUENCY function as an array formula using Control+Shift+Enter.
Europe spends much per average customer. The global ranking shows Europe is doing pretty well, considering Norway is the number two with $2,448 spent online per average customer in 2015. Only the average revenue per user in Hong Kong was higher, with $2,868.
Spending and Age. According 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.pending and Age. According 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.