By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: How to Track Your Data for Six Sigma Use
Share
Notification Show More
Latest News
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security
ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Analytics > How to Track Your Data for Six Sigma Use
Analytics

How to Track Your Data for Six Sigma Use

knowwareman
Last updated: 2011/12/13 at 5:45 PM
knowwareman
4 Min Read
SHARE

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.

More Read

database compliance guide

Four Strategies For Effective Database Compliance

Discover the Power of Analytical Insights in Your Business Data
The Importance of Implementing a Sensible Data Collection Strategy
Quality Control Tips for Data Collection with Drone Surveying
How to Bring Presentation Data to Life with Powered Template

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.”) 

TAGGED: data, data collection, six sigma
knowwareman December 13, 2011
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

database compliance guide
Data Management

Four Strategies For Effective Database Compliance

8 Min Read
analytical insights for business data
Analytics

Discover the Power of Analytical Insights in Your Business Data

5 Min Read
why your business needs the right data collection strategy
Data Collection

The Importance of Implementing a Sensible Data Collection Strategy

7 Min Read
data collection with drone use
Data Collection

Quality Control Tips for Data Collection with Drone Surveying

9 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?