dcsimg
 

Quartile Analysis for Process Improvement

quartile analysis for phone center duration dataThe value of analyzing data is well established in industries like manufacturing and mining, but data-driven process and quality improvement is increasingly being adopted in service industries like retail sales and healthcare, too. In this blog post, I'll discuss how a simple data analysis may be used to improve processes in the service sector.

Suppose we want to improve the way incoming calls are processed in a call center run by a large insurance company. We are interested in analyzing duration metrics, which are very useful in assessing both the experience of customers—who always appreciate quick processing of incoming calls—and issues of employee productivity, such as which tasks are the most difficult to deal with.

If two customers call with exactly the same objective, process durations will certainly differ, because each employee will process the calls in a slightly different way. In addition, the customers may react differently to questions asked by the call center operator, and many other factors can influence the duration of the call.

Collecting Process Data

The process map below illustrates the 12 sequential steps involved in processing the incoming calls in this example.

Process Map

Some tasks are performed during the one-to-one conversation with the customer (Preliminary analysis, Database search, Data Entry …), and other tasks are done immediately after the phone call, while the customer is waiting to receive  the final document.

The task durations have been measured for each step of each call received, over a reasonable period of time. Our objective is to transform this large quantity of raw data into useful information, and to calculate summary statistics.

We are interested in analyzing the amount of variability in the time it takes to complete each task. We would like to better understand which steps in this process generate the largest amount of variability.

Using Quartile Summary Statistics to Analyze Variability

Analyzing variability using quartile summary statistics may play an important role in benchmarking. For example, we can seek to understand if there are large differences in processing times for a particular step, and then gain an insight into what accounts for the differences. Is the task duration affected by having more experienced operators, different levels of knowledge, or better practices?

Quartiles represent the value for which 25% of the data is below (Q1) and the value for which 25% of the data is above (Q3). The Interquartile Range (IQR) is the difference between these two quartiles (Q3 – Q1 = IQR). A major advantage of using the Interquartile Range (IQR) to estimate variability is that it is much less sensitive to outliers than the variance or the Standard Deviation summary statistics.

The Box Plot below shows the Q3 values (upper bounds of the boxes) for each of the twelve process steps, as well the Q1 values (lower bounds of the boxes) and the outliers which are indicated by asterisks beyond the whiskers.  The height of the rectangular boxes for each group represent the middle 50% (interquartile ranges) of the data.

Boxplot

Minitab Statistical Software has been used to compute the IQR values for the 12 steps and display them on the bar chart graph below.

IQRs

Q1 (the first quartile), Q3 (the third quartile) and the IQR for the 12 process steps are shown in the bar chart below.

Q1, Q3 and IQR

You can see that the IQR is much larger for the follow-up calls (12th step). The IQRs are also large for the 2nd, 3rd and 4th steps (Preliminary analysis, Database search and Evaluation) during the initial conversation and for the 10th step (Recordkeeping) after the one-to-one conversation. Because the differences for these specific tasks are significant, we might have an opportunity to reduce durations.

These variations might be due to different levels of knowledge for the more complex tasks. Can we set best practices for these tasks ? Can we identify what the best practices are ? Do we need to standardize the way follow-up calls are carried out ? Do we need to redefine what we expect from a follow-up call ? Could the large differences for the database search and for the record keeping tasks be due to different levels of knowledge of the customer relations management (CRM) database? Perhaps not all employees feel comfortable using the company CRM system.

Now that we've identified the tasks with the most potential for improvement, we can begin to see which factors might have the most influence on the variation we've seen.

If you'd like to try this yourself, download the Minitab project file here.

The Power of Quartile Statistics

Quartile statistics possess a great deal of analytical power and are a very useful technique for benchmarking purposes. These statistics are used less often in the service sector than in manufacturing, but more and more businesses are learning how even very simple summary statistics such as quartiles can help you identify the steps that can easily be improved.

 

Comments

Name: Omar Mora • Sunday, October 20, 2013

Bruno,
This is a great post. We do need more examples for service-transactional-business. Thanks-
Question:

How do I store the IQR for multiple Y´s in Minitab16?

I would like to record a video to show my Spanish-spoken Minitab community how to do it.

Omar Mora


Name: Bruno Scibilia • Monday, October 21, 2013

Hello Omar,

Thank you for your interest.
To store the InterQuartile Range (IQR) by process step, in a Minitab worksheet, go to : > Stats > Basic Stats > Store descriptive Statistics

In the dialogue Box :
In variables : Enter your Process times
In By Variables : Enter your Process steps/phases
Click on Statistics just below in the same dialogue box and check : Interquartile Range
in order to store the interquartile ranges by steps/phases in the Minitab worksheet.

Bruno Scibilia


Name: Pier • Monday, March 10, 2014

Very interesting use of IQR.
Could you plase share also the data set used in this example. I'm a Six Sigma trainer and I'd like to present this example in my classrom.
Many thanks...Bruno


Name: Bruno Scibilia • Tuesday, March 11, 2014

Thank you for your interest in this blog, here is the link to the Quartile analysis dataset : http://cdn2.content.compendiumblog.com/uploads/user/458939f4-fe08-4dbc-b271-efca0f5a2682/479b4fbd-f8c0-4011-9409-f4109cc4c745/File/a1db2c6ea0b7e497df0acfb59672c8de/quartile.MPJ


blog comments powered by Disqus