It can be tricky to decide which aggregator to use, especially when it comes to average and median. You can always use both of them - one metric to calculate the average and another the median. This lets you see which measure will be most useful in a particular case. However, understanding these statistical terms will make it easier to choose the right aggregator.
Average(ormean) andmedianplay the similar role in understanding the central tendency of a set of numbers. Average has traditionally been a popular measure of a middle point in a set, but it has a disadvantage of being influenced by single values which are much higher or lower than the rest of the values. That’s why the median is a better midpoint measure for cases where a small number of outliers could drastically skew the average.
Average Median
Definition |
The average is the arithmetic mean of a set of numbers. |
The median is a numeric value that separates the higher half of a set from the lower half. |
When is it applicable? |
The mean is used for normal number distributions, which have a low amount of outliers. |
The median is generally used to return the central tendency for skewed number distributions. |
How is it calculated? |
The average is calculated by adding up all the values and dividing the sum by the total number of values. |
The median can be calculated by listing all numbers in ascending order and then locating the number in the centre of that distribution. |
Example:Normal distribution |
2, 3, 3, 5, 8, 10, 11 (2+3+3+5+8+10+11)/7= 6 AVG = 6 |
2, 3, 3,5, 8, 10, 11 MED = 5 |
Example: Skewed distribution |
2, 2, 3, 3, 5, 7, 8, 130 (2+2+3+3+5+7+8+130)/8= 20 AVG = 20 |
2, 2, 3,3,5, 7, 8, 130 (3+5)/2=4 MED = 4 |
Conclusion
If the data you are comparing is mostly uniform then you can safely use the average (AVG) aggregator. However, if your number set has some outliers then you need to consider using median (MED) to filter out the values that are skewing the results.
Examples
A few practical examples:
- In order to report on full resolution time, use the Explore完整的解决时间(小时)(地中海)metric. Choose the median operator because a number of tickets have been under investigation for a while and these tickets might skew your report.
- To check the average amount of replies posted by the agents use the# Replies [MED]metric because the number of replies is more or less constant.
- To figure out how fast the support team replies to new requests, use the ExploreFirst Reply Time (hrs) [MED]metric. Since first reply time is normally constant, create a metric that will count the average first reply time. Additionally, you can filter out proactive tickets, created by agents from the report because they might have a high first reply time.
2 Comments
Hey!
We have been comparing AVG and MED metrics over time, and usually, the difference is small - a few hours.
However, for the month of December and June, the AVG number isx2, which is rather strange. I wonder the best way to figure out why it is so? I would appreciate your ideas and response!
It could be normal as median and average would vary depending on the number of values. The more data you have, the bigger the difference between the maximum and the minimum would be, it will then inflate the average. That's why in some circumstances the median makes more sense, especially for duration metrics.
I would recommenddecomposingthe data and checking manually to be sure, and if you need help to double-check your report, don't hesitate tocontact our support.
Pleasesign into leave a comment.