## Why we cannot take the average of averages?

Once upon a time, I was questioned with the above.  First thing on my mind: “Is it a test?”… So I answered the question carefully, as shown in the screen shot below:

I think this is quite basic and straight forward.  Isn’t it? To my surprise, it is not.  Many people would take simple average for averages or rates.  Here’s another example: To get the correct answer, we have to find out the total number of  Transactions, then divided it by total number of Traffic.  Simple average would NOT give you the grand average for this kind of data.  If the components (Traffic or Transaction) are missing, there is no way we can get the correct conversion rate for all shops.

Tips: If you are using Pivot Table to summarize the above information, DO NOT use the field “Conversion Rate” directly.  You have to do it by Calculated Field.

Mind the average trap for various “Rates”.  Did you experience or witness this kind of trap in your workplace? Feel free to share with us in the comment.

Different people have different definitions of “Basic”.  Don’t take “Basic” for granted. 🙂

Advertisements
This entry was posted in Formula and tagged . Bookmark the permalink.

### One Response to Average Trap 2 – Average the average

1. Pingback: Average Trap | wmfexcel