spranger business solutions
  • Home
    • Appearances
    • Contact
  • Services
    • Lean Six Sigma for Businesses
    • Lean Six Sigma for Individuals
  • Blog
  • Store
  • CWBEX - Spring 2020

Understand the Problem with Data

5/23/2016

1 Comment

 
Picture
Imagine this – your business has a critical issue to resolve (if you have a burning issue right now – think about that).  If you are like a typical organization, a meeting will be called with a half dozen or more people to “discuss” the issue and course of action.  What’s too bad is these “discussions” typically involve one or two people sharing their opinion (sometimes rather loudly) and the rest of the people listening passively and agreeing.  Raise your hand if you have ever been in this meeting before.  Ok, now put your hand down.

My Opinion is Louder Than Yours!


Opinions are great.  They are an essential part of an improvement effort.  But, when decisions are solely based on opinions and especially when they are based on a limited number of opinions, it can lead a team astray.  Teams that operate this way fall into the trap of confusing activity with improvement.  Sort of like rearranging the deck chairs on the Titanic.  It doesn’t matter – this ships going down!


Sure, finding the right data can slow things down a bit, but...

There is a difference between obvious decisions and ones that need more data to point in the right direction.  I don’t think anyone would need to collect data before replacing a roll of toilet paper on the hanger.  You can see the bare cardboard tube; you know it is gone.  That’s all the data you need.  Hang the new paper. 

But when someone is making claims like, “this happens all the time” or “it’s gotten really bad” – that’s your indicator.  Does it happen all the time?  Like, every single time?  Most of the time?  A lot this week? 

Translation: If the problem is obvious and the solution is simple - just fix it.  But, if the problem is vague and you’re not really sure - go grab some data.
 
Wouldn't it be nice to know before we start trying to fix it?

When I hear these indicator words (always, never, a lot, quite a bit, etc.) I like to use what I call the 12-15 guideline.  This method provides a measurement baseline that is quick, simple, and effective at providing a general idea of past performance.   
  1. Find data for the last 12 “periods” and randomly select 15 data points for each period. 
  2. Calculate average values for each period. 
  3. Plot the average values in time series order (the sequence in which they occur).

Performing these simple steps will make it easy to see any trends or outliers, and understand the magnitude of the problem.  (Check out the helpful links at the bottom for assistance on steps 2 and 3.)

​But what if there is "no way" to measure your problem?  Think about it.  There is a way that data can describe the problem you are experiencing.  Besides, you don't want to pour a lot of effort into something you "think" is a problem only to "not really know" if things are better once all of the action is complete. 

Some helpful links: 

Using the Average Function In Excel:  https://support.office.com/en-us/article/Calculate-the-average-of-a-group-of-numbers-e158ef61-421c-4839-8290-34d7b1e68283
Creating a Time Series Plot In Excel:  https://www.youtube.com/watch?v=SAgldvOtrhI


Picture

​Want to receive free tips to help improve your business? 

Subscribe Here

1 Comment
<<Previous
    Picture

    Author

    Christopher M. Spranger, MBA, ASQ MBB

    Archives

    February 2021
    December 2020
    July 2020
    August 2017
    July 2017
    April 2017
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    February 2013

    Categories

    All
    Culture Development
    Data Analysis
    Healthcare Analytics
    Improvement
    Lean
    Prioritizing
    Project Facilitation
    Project Management
    Six Sigma
    Standard Work
    Time Management

    RSS Feed

    Want to receive free tips on how to use Lean Six Sigma to improve your business?

    Subscribe Here
Copyright © 2018  | Helping Business Leaders Save Time and Money through the Application of Lean Six Sigma |  Spranger Business Solutions  |  715.451.5324
  • Home
    • Appearances
    • Contact
  • Services
    • Lean Six Sigma for Businesses
    • Lean Six Sigma for Individuals
  • Blog
  • Store
  • CWBEX - Spring 2020