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.
The amount of time young people spend online has trebled in the past 10 years, while 70pc of adults feel comfortable giving away personal information. Almost 40pc of 16-24 year olds regularly use online TV catch-up services Photo: Getty.