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.
Average Order Value What Is Average Order Value (AOV)? Average order value (AOV) tracks the average dollar amount spent each time a customer places an order on a website or mobile app. To calculate your companyâs average order value, simply divide total revenue by the number of orders. For example, letâs say that in the month of September, your web storeâs sales were $31,000 and you had a total of 1,000 orders. $31,000 divided by 1,000 = $31, so Septemberâs monthly AOV was $31.