How to Track Your Data for Six Sigma Use

December 13, 2011
3 Views

While most companies have too much data, people can always identify something they aren’t tracking that they should be tracking. Then they think they have to set up a whole system to collect the measurement. This is a mistake. You don’t know if the measurement is useful until you have collected some. Rather than wait for a measurement system, start today using the simplest of tools: a checksheet.

checksheet

While most companies have too much data, people can always identify something they aren’t tracking that they should be tracking. Then they think they have to set up a whole system to collect the measurement. This is a mistake. You don’t know if the measurement is useful until you have collected some. Rather than wait for a measurement system, start today using the simplest of tools: a checksheet.

checksheet

I’ve use these kinds of checksheets when I’m working with a team to implement Six Sigma. They find causes, I write them down and tally the number of times each occur. By the 30th data point, a pareto pattern appears that points us at the most common (i.e., root) cause of the problem.

Checksheet Data Collection
Nothing could be simpler than data collection with a checksheet. The QI Macros have a template in the improvement tools to get you started:

Excel Checksheet for collecting data

Simply print it out and start writing on it. What to write?

  • In column A, write the first instance of any defect, problem or symptom you detect. For example, if someone is calling us for support and they have a problem with understanding GageR&R, then we’d write “GageR&R” in A3 and put a stroke tally in the day of the week (e.g., Monday):

    Excel Checksheet with stroke tally

  • Then continue as the week goes on, adding defects, problems or symptoms. By the end of the week, we’ll have an interesting picture of support calls.

    Excel Checksheet for support

Just add up the number of calls and “Excel disabled macros ” jumps out as the majority of the calls. Create a pareto chart to better demonstrate this.

Pareto chart in Excel of Checksheet data

But now the questions arise:

  • Does a specific version of Excel disable the macros?
  • What are the SPC Questions about? Histograms? Control Charts? Which control chart?
  • And so on.

Well, if we spent a lot of time and money setting up a measurement system to track just these items, it wouldn’t do us much good. Now we can tune up the checksheet to give us better data:

Excel Checksheet for support revised

Use a checksheet to prototype your data collection efforts. Iterate until you start to understand what you really need to know to make improvements. A series of checksheets may be all you need to solve a pressing problem. If necessary, you can implement a measurement system to collect the data over time.

So please, don’t wait for a magical, all encompassing measurement system to deliver data. It’s not going to happen. And I often find it’s just an excuse to avoid making improvements (“I can’t because I don’t have the measurements I need.”) 

You may be interested

3 Indispensable Ways to Reach Your Marketing Potential with Data
Business Intelligence
0 shares165 views
Business Intelligence
0 shares165 views

3 Indispensable Ways to Reach Your Marketing Potential with Data

Rohan Ayyar - May 23, 2017

Today, all marketing is done on the back of data. Marketers know their decisions and actions must have a rationale…

How Did Big Data Create a Modern Day Manufacturing Workforce?
Big Data
0 shares243 views
Big Data
0 shares243 views

How Did Big Data Create a Modern Day Manufacturing Workforce?

Megan Ray Nichols - May 23, 2017

Despite its relatively brief lifespan thus far, big data is poised to reinvigorate the U.S. manufacturing workforce. Some of the…

4 Easy Steps How to Conduct IT Security Audit of Your Own Company
IT
0 shares304 views
IT
0 shares304 views

4 Easy Steps How to Conduct IT Security Audit of Your Own Company

GoganMarcell - May 22, 2017

Businesses often view data security audit as a stressful and intrusive process. Auditor walks around distracting everybody and meddling in…