Averages hide the extremes
I can't remember where I first heard it, but "averages hide the extremes" can be a really useful guide when thinking about how you manage data. Here's a nice illustration from one of my clients:
As they looked at their event registration they saw an average of 100 registrations per month over the course of six months. But a closer look showed that the first month of registration and the last month of registration was where the bulk of those registrations came in. In fact, if they removed the first and last month, the average number of registrations per month was actually more like 50.
The same also happens frequently with membership joins and renewals, certification, and other types of sales.
What this means is averages can be misleading. Basing a decision (e.g., staffing, technology, business processes) on the average number of transactions may lead to some choices that won't serve you well. So be sure to dig deeper when discussing averages.
And on a related note: Using the extremes (rather than the averages) can also be misleading because "extremes" is just another word for exceptions.
![]()
Wes's Wednesday Wisdom Archives
Don’t forget to celebrate!
Don’t forget to celebrate! Truth be told, I’m not a big celebrator. (Maybe it’s because […]
Three thoughts on duplicate records
Three thoughts on duplicate records Duplicate records are a reality in any database of any size, […]
Please don’t do this…
Please don’t do this… I’ve noticed a trend among online retailers that I want to […]
AI is perpetually patient
AI is perpetually patient My friend and colleague Noel Shatananda of fusionSpan was providing me some […]
User adoption is (almost) all that matters…
User adoption is (almost) all that matters… I was speaking with an association recently about their […]
When “overcommunicating” becomes overwhelming
When “overcommunicating” becomes overwhelming There is a common belief in project management and general business management that overcommunicating […]
Communicating when there is a major technology change
Communicating when there is a major technology change For those of you who are ASAE […]
Everything works, until it doesn’t.
Everything works, until it doesn’t. “If something cannot go on forever, it will stop.” – […]
Some things are unknowable
Some things are unknowable One of the most challenging aspects of moving to a new […]
Do we have access to that data?
Do we have access to that data? When I work with my clients on a […]
