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.
1 The average time spend by users is 16 hours per month (32 hours for US residents). 2  Social networking is the most popular and time consuming online activity â with users spending more than one fifth (22%) of their time engaging on social media channels.