Visual Presentation of Data

home · products · services · search · view cart · contact  
 
  NAVIGATION        
 

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar

2253 S. Oneida
Ste 3D
Denver, CO 80224


We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011



 

I recently stumbled over a book called Visual Explanations by Edward R. Tufte (Graphics Press, Cheshire, CT, 1997). The New York Times called him "the Leonardo da Vinci of data." Tufte says:

There are right ways and wrong ways to show data; there are displays that reveal the truth and displays that do not.

Space Shuttle Challenger

Tufte tackles the data and presentation used by Morton Thiokol to show O-ring damage on previous shuttle flights. The graphs used cute little rockets to show O-ring damage over time:

Unclear Chart

The temperature at time of launch is shown on rocket A and the O-ring damage on the recovered boosters shown as gray or hatched areas. As you can imagine, put 50 of these in a row and it's hard to tell what's really going on.

If, however, you use the O-ring data to draw a scatter plot shown below, you can use the trend line to back into the potentially catastrophic problems awaiting the space shuttle Challenger:

Scatter Diagram in Excel

If you use a c chart to plot the damage index, you get a chart that tells you that the one 53 degree launch is special cause variation, but also that the entire launch sequence is unstable:

c chart in Excel

If the process was this unstable, maybe it needed some serious root cause analysis before liftoff.

The Right Picture is Worth a Thousand Words

Information displays should serve the analytic purpose at hand.
Here are some of Tufte's insights:
  • Numbers become evidence by being in relation to something. The numbers indicating the temperature on the rockets aren't really in relationship to anything. Similarly, numbers on a spreadsheet can be hard to read.
  • The Disappearing Legend - When the legend on a chart is lost (in this case the meaning of the gray areas on the rockets), the insights can be lost as well.
  • Chartjunk - good design brings absolute attention to data. Bad design loses the insights in the clutter.
  • Lack of clarity in depicting cause and effect. In the rocket charts, no matter how cute, the cause and effect of temperature vs. O-ring damage is lost.
  • Wrong order - a fatal flaw can be in ordering the data. A time series (i.e., a control chart) may not reveal what a bar chart (i.e., a histogram) might reveal. In this case, a scatter diagram reveals all you need to know

Here's my point

I usually draw as many different charts from the same data as I can to see which one tells the best story. You should too. Every picture tells a story, but some pictures are better than others at telling the story. The QI Macros make it easy to draw one chart after another so that you can quickly discard some of them and select others that engage the eye in the real issues.

As Tufte would probably say: Don't let your charts become disinformation. There's enough of that in the world already.

To purchase the QI Macros

QI Macros - One License Per Computer - Download with backup CD & User Guide (#230) $199 + S&H
QI Macros - One License Per Computer - Download Only - No Shipping or Customs Duties (#W230) $199


If you already own the QI Macros, you can purchase an upgrade. You must purchase one upgrade for each license you own.

QI Macros Upgrade - One License Per Computer - Download with backup CD and user guide (#232) $99 + S&H
QI Macros Upgrade - One License Per Computer - Download Only - No Shipping or Customs Duties (#W232) $99


If you love the QI Macros...
Please ask a handful of friends to download the trial version. Here's what to say:
Need easy to learn, easy to use software for Lean Six Sigma and SPC that works right in Microsoft Excel? Test drive the QI Macros!
Find out more at www.qimacros.com/excel-spc-software.html.
Get a 30-day trial at www.qimacros.com/free-spc-software.html.

Going to a meeting of quality professionals?
We can send you as many QI Macros 30-day trial CDs as you need. Just send an email with the address and quantities needed to orders@qimacros.com.

 

Try QI Macros
FREE
For 30-Days


Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee


 
home | products | services | search | sitemap | view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training