Scatter Plot Matrix or Matrix Plot Diagram in Excel


© 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!

Scatter Matrix Plot Diagram

Matrix Plot Diagram

Purpose: matrix-plot (a.k.a. scatter plot matrix) diagrams are used to evaluate the correlation or cause-effect relationship (if any) between two or more variables (e.g., color, residue and perceived quality in shampoo).

When you're investigating cause-effect links between two or more indicators then you can use the matrix plot diagram to quickly identify. If the points are tightly clustered along a line like machine gun stitching, then there's probably a strong correlation. If it looks more like a shotgun blast, there is no correlation.

How to create a Matrix-Plot Diagram:

  1. Select two or more columns of data:
    Matrix Plot Diagram Data
  2. Click on the QI Macros pull-down menu and select "Matrix Plot".
  3. Enter titles for your chart when prompted.
  4. Analyze and interpret the results.
For more information, click here: nist.gov

The Matrix Plot Diagram is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Buy the QI Macros Now! Unconditional, No Questions Asked, 90-day Money-Back Guarantee!

Buy QI Macros Excel SPC Software for Histograms and Control Charts Now QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H


© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home | Lean Six Sigma | QI Macros | KnowWare | Site Map

QI Macros 30-day Trial & FREE QI Macros Course
Name:
E-mail
 

QI Macros SPC Software for Excel
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.

Buy All-in-One, Excel SPC Software Now

Quantity Discounts

Customer Testimonials

Minitab Comparison

QI Macros FAQs

FREE Lean Six Sigma Course
& QI Macros 30-day Trial
Name:
E-mail