Do you measure the spread of data?

business charts to measure the spread of data

Performance reports and dashboards often report the average values. Usually we plot the average values over a period of time to monitor trend. However when measured alone, averages tend to lie. Yes, mean alone is meaningless. It is important that you measure the spread of data.

Let us discuss a couple of examples. These examples emphasize on the importance to measure the spread of data along with the average values.

Example 1: Online store for baby products

Nisha is a small business owner. She had started her online store for baby products a year ago. Business had picked up well after the first few months. She now receives 6 to 8 orders per day. She has a team of 3 employees. “On time delivery” is an important parameter for her business and they promise deliveries within 3 days to all customers. Nisha reviews on time delivery performance every week with her team. Given below is the summary for last week:

  • Total orders received: 48
  • Average delivery time: 2.92 days
example for measure the spread of data. Days to deliver

So on an average, every order was delivered within the 3 days target set by Nisha. However, if Nisha were to measure the spread of data for order delivery, more than 1/4th orders were delivered late – 13 out of total 48 (27%).

Nisha and her team need to look at the entire distribution and not just the “Mean” or average delivery time. How would the 2 customers rate their shopping experience who received the product on the 6th day?

Example 2: Customer Helpdesk

ABC Pvt. Ltd. is a leading internet service provider and employs a team of 120 customer service representatives to manage their inbound call center. While reviewing customer feedback, they have identified “call wait time” as one of the major dissatisfiers for customers who contact the helpdesk. During peak hours, wait time could be as high as 7 to 8 minutes.

The management team introduced “Average Call Wait Time” as a key metric for the customer helpdesk. The target was to maintain an average call wait time of less than 3 minutes.

The team managed to reduce the call wait time and in the 3rd month, they reported an average call wait time of 2 minutes, 27 seconds (Mean).

Example of call wait time to measure the spread of data

However, if we review the overall call distribution, 18% callers had to wait for more than 3 minutes. Some callers had to wait beyond 4 minutes. While the team had managed to significantly reduce the call wait time, they need to continuously improve the performance to reduce the variation.

Both Nisha and ABC Pvt. Ltd need to look beyond the averages and measure the spread of data. Hence, along with the mean, they need to observe the variation in the process.

The extremes on both sides of the curve strongly influence customer behavior. A customer who had to wait for 6 days will most likely be dissatisfied and may not return for a second purchase. A caller may hang up after waiting for 4 minutes in the call queue. Hence the query would remain unanswered and unresolved.

Do you measure the variation for your business processes?

Do you look at the extreme values?

How to measure the spread of data?

While there are statistical tools to monitor data distribution and variation, small businesses can follow a simple approach to monitor variation:

  • Set service level goals or specification limits for all key customer metrics (on time delivery, turnaround time etc.)
  • Set up a data reporting and monitoring schedule
  • Along with mean, observe the variation – monitor the count and percentage values beyond the desired service level or specification limits (Example: count and percentage of orders delivered after 3 days OR count and percentage of callers who had to wait for more than 3 minutes OR count or percentage of inquiries not responded to in 24 working hours)

Understanding the variation along with the average performance and addressing the root causes for variation will help you better conform to customer expectations.

Share your views