Anyone else guilty of using median but labeling it as average?

Question

Pretty much got tired of explaining to sales folks why median was better than average for the dataset and explaining what median actually is.

Posted Mar 29, 2023, 5:57 PM UTC

57
0wmeHjyogG•

Just to make sure I’m following - you have something labeled as “average”, which people expect to be the arithmetic mean, but you’re actually calculating the median. Is that right?

I don’t know about where you work, but intentionally mislabeling something would not be well received anywhere I’ve been.

You might want to communicate with a larger and more senior audience as to why the arithmetic mean is misleading and why you believe the median to be a better metric. And then have both available.

19
dangerroo_2•

Median is an average, along with mean and mode. The average is just a measure of central tendency, the mean being one way to do that.

So you are not technically wrong! And I appreciate the desire not to have to explain what something other than the mean is.

15
Keruimin•

Seems like you should not mislabel as that could come back to bite you in the ass. Seems these values could be very different depending on if the data has a skew or not.

8

Sales be like: " yah but what's the avg median?"

5
HumbleChallenge•

What is the avg of the following numbers

1, 4, 6, 9, 40000000000

Now what is the median? You cant name it one thing and populate data from another field.

If this got to production and you hid it from the team I would honestly have you fired. This is how people get embarrassed or data driven decisions work off incorrect data.

If you are the analyst then make your case but intentionally mislabel a field?

Maybe “for cause” i don’t know I’m not in HR.

4
AutoModeratorMOD•

If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1
tenplusacres•

I hear what you're saying, but it might not be a bad idea to include an asterisk and disclose the difference somewhere in the document / final product.

Obviously in an ideal world your work would be consumed by a knowledgeable audience but, uh, sales is not always that.

1