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.
China is set to overtake the United States this year as the largest online shopping market in the world, according to Forrester Research. Chinese consumers are expected to spend $290 billion at online retail sites this year, compared with $260 billion for their counterparts in the United States.n all, Ms. Yuan spent 1,500 renminbi, or nearly $250, before calling it a night. That, Ms. Yuan said, represented about half a monthâs living costs for her. âWe love window-shopping in the local department store,â Ms. Yuan said. âBut we have never spent so much money in one day.