Have you attributed your results to the right base data?

It may come as a surprise that the biggest challenge facing black belts and master black belts is usually not in selecting the best statistical technique for analyzing a particular data set. Most statistical techniques work fairly well even if the underlying assumptions are not precisely correct. If a black belt supplements the numerical analysis with graphical evaluation, the chance of making grossly erroneous decisions is negligible.

A mistake that is far more serious–but far more common–is comparing the results of a study to the wrong base data. These “apples to oranges” comparisons often lead to poor decisions and, worse still, to inaccurate beliefs that can derail faith in the Six Sigma approach itself. A recent incident with a client brought this point home for me.

The situation involved a project in the sales organization of a software company. The company had several sales teams and wanted to know if a new approach to closing the sale would improve the rate of closing sales. The company didn’t have a Six Sigma program, and the project was planned and carried out without black belts. The results were presented to management in a classic form: a bar chart (see Figure 1). The team had declared victory, and management–convinced by the “data”–prepared to revamp the sales training to incorporate the new approach companywide. All of the leaders looked forward to the bottom-line improvement they’d see from a 29-percent improvement in the sales closing rate.

Figure 1: Sales Closing Rate Improved by New Approach

All of the leaders, that is, except Lorraine. She’d received green belt training from her previous employer, and she’d seen enough black belt presentations to know that the analysis of the sales team was seriously flawed. It was undeniable that the project team’s sales close rate was 2.53 percent higher than the sales close rate for the rest of the sales department during the 16 weeks of the test, and, yes, the 2.53 percent did represent a 29-percent improvement over the 8.83-percent rate for the rest of the team. Despite these “facts” and the air of scientific objectivity surrounding the analysis, Lorraine had many unanswered questions. She asked management to delay any decision until she could explore these questions with a Six Sigma consultant. That’s where things stood when I entered the picture.

Lorraine viewed the analysis as important because it would demonstrate that the Six Sigma approach could be applied in this service company, something that skeptical managers didn’t believe. In a meeting with the sales team leader, I was presented with the data shown in Table 1. As often happens, this summary data was all that was available; for a variety of reasons (but chiefly due to a time constraint) the number of sales calls used to compute these rates could not be obtained.

WeekNewOld
10.12350.1106
20.13130.1000
30.10510.9580
40.09790.0980
50.09200.0828
60.05410.0793
70.09320.0703
80.08640.0685
90.09530.0610
100.12040.0672
110.10460.0674
120.16220.1063
130.15050.1059
140.15100.1145
150.11670.1055
160.13400.0794
Average0.11360.0883
Table 1: Old vs New Closing Rates

If you are a Lean Six Sigma Black Belt or Master Black Belt, or just statistically inclined, please take a couple of minutes before reading the remainder of this post to think about the data and jot down how you’d proceed from here.

When dealing with the data in Table 1, it’s tempting to apply a statistical technique such as a paired t-test to it. Using Microsoft Excel, it’s a simple matter to compute the t-statistic, which is 4.55, a highly significant result. Statistical purists would ask if the data are approximately normal and an endless variety of other technical questions about the data. I would argue, however, that all of this is premature and, ultimately, beside the point. The first order of business is to determine if we are comparing apples to apples.

Further discussion revealed that the company had not two but nine sales teams, all of the same size. A further complication was that the teams sold different products. More probing uncovered the fact that four of the eight other teams sold a product mix similar to that of the team using the new closing method. At this point it appeared that, to make an apples-to-apples comparison, you would assess the results of these five teams for the 16-week project. Descriptive statistics are shown in Table 2.

Descriptive Statistics
TeamNMeanStandard DeviationMinimumMaximum
4160.11520.049720.050.2
5160.088140.023860.050.13
7160.11820.033720.070.17
8160.14810.037990.110.24
New160.11360.028170.050.16
Table 2: Apples-to-Apples Comparison

Further analysis using nonparametric methods indicated that there are three distinct groups in these data (see Table 3).

GroupTeam(s)Respective Closing Rate(s)
158.81%
24, 7 and new11.52%, 11.82% and 11.36%
3814.81%
Table 3: Data Groups

Table 3 presents a decidedly different picture than was originally given to management. The new closing method now appears to be no better than normal. Still, there are bright spots. Assuming that teams 5 and 8 aren’t oranges being compared to apples, potential gains should be possible from discovering why team 5 performs under the norm, and why team 8 outperforms the norm. More information might also be obtained by plotting the 16 weeks over time to identify trends and other patterns. Using the Six Sigma approach, the information can be converted to knowledge, the knowledge to action, and the action to an improved bottom line. It’s more work than the old standby, the bar chart, but it’s worth it.

The complete data file used in this post can be downloaded on the link below.

The challenge is to analyze the data in a number of different ways to determine how the different analyses would affect management decisions. Send your results to me for inclusion in a future post.


Leave a Reply

Your email address will not be published. Required fields are marked *

Sign up for Pyzdek Institute Newsletter
Get the latest Lean Six Sigma insights, tips, and updates directly in your inbox.
* = required field