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.
But 22% of men made a purchase on their smartphones last year, compared to 18% of women. Millennials, those consumers aged 18 to 34, remain the key age demographic for online commerce, spending more money online in a given year than any other age group. They spend around $2,000 annually on e-commerce.