|
© 2007 KnowWare
International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224
Jay Arthur
888-468-1537
303-756-9144
Email Us
We help people think!
|
|
There are so many different kinds of charts.
How do you decide which one to choose? One of our customers asked for a
"cheat sheet" so here it is.
| If your data is organized by... |
And your data looks like this in Excel... |
Choose one of these charts... |
Category
(e.g., type of defect, city, state, country, male/female, etc.) |
Headings + Integers or Decimals:
 |
Pareto Chart
Bar Chart
|
Cause and effect
(e.g., calories vs weight gained, variation vs warranty claims, etc.) |
Two columns/rows of numbers:
 |
Scatter Chart
Matrix Plot
|
Time
Attribute Data
(days, hours, batch number, lot number, etc.) |
One column of Integers
 |
c Chart
|
Time
Attribute Data
(Counted) |
Headers (time, lot number)
1. Defects (Integer)
2. Sample size (contant integer)
|
np Chart
|
Time
Attribute Data
(Counted) |
Headers
1. Defective items (Integer)
2. Sample size (variable integer)
|
p Chart
|
|
Time
Attribute Data
(Counted)
|
Headers
1. Defects (Integer)
2. Sample size (variable integer)
|
u Chart
|
|
Time
Variable Data
(Measured)
|
Headers (time, lot number)
1. Decimals
|
XmR Chart
Histogram
|
Time
Variable Data
(Measured) |
Headers (time, lot number)
2-5 columns of Decimals
 |
XbarR Chart
XMedianR
Histogram
|
Time
Variable Data
(Measured) |
Headers (time, lot number)
5-25 columns of Decimals
 |
XBarS Chart
Histogram
|
© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home
| Lean Six Sigma
| QI Macros
| KnowWare
| Site Map
|
Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee
The QI Macros for Excel $139,
is an inexpensive easy to use set of Excel add-ins for statistical process control
and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp,
Cpk), scatter and control charts (with stability analysis).
It contains over 70 fill in the blank templates such as the Ishikawa diagram,
QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test,
and regression analysis.
Quantity Discounts
Customer Testimonials
Minitab Comparison
QI Macros FAQs
|
