Averages hide the extremes

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

But are you really willing to change?

September 22, 2021

But are you really willing to change? When any organization is making a change in data management …

But are you really willing to change? Read More »

Two tips for data conversion

September 15, 2021

Two Tips for Data Conversion I’ve written a lot about data conversion over the years …

Two tips for data conversion Read More »

Who should “own” the database?

September 8, 2021

Who should “own” the database? One of the most common questions I get from my …

Who should “own” the database? Read More »

What makes you weird?

September 1, 2021

What makes you weird? When I work with clients on selecting a new association management system, one …

What makes you weird? Read More »

Why “AMS Consortiums” Don’t Work

August 25, 2021

Why “AMS Consortiums” Don’t Work About once a year I will get a call from …

Why “AMS Consortiums” Don’t Work Read More »

Your vendor will disappoint you

August 18, 2021

Your vendor will disappoint you I follow politics as a hobby. A past publisher from …

Your vendor will disappoint you Read More »

Learn how to lose

August 11, 2021

Learn how to lose “Winning is great, sure, but if you are really going to …

Learn how to lose Read More »

Ownership is Required

July 28, 2021

Ownership is required When asked for the most common reason AMS implementations fail, I typically respond …

Ownership is Required Read More »

It’s all relative…

July 21, 2021

It’s all relative… Over the course of my 22 years of consulting, I’ve consulted with …

It’s all relative… Read More »

Eliminate to optimize

July 14, 2021

Eliminate to optimize So much of data management is habit (both good and bad) which is …

Eliminate to optimize Read More »

Scroll to Top