Scatter Plot Using SigmaXL

What is a Scatter Plot

A scatter plot is a diagram to present the relationship between two variables of a data set. It consists of a set of data points set on two axis. On the scatter plot, a single observation is presented by a data point with its horizontal position equal to the value of one variable and its vertical position equal to the value of the other variable. A scatter plot helps us to understand:

  • Whether the two variables are related to each other or not
  • What is the strength of their relationship
  • The shape of their relationship
  • The direction of their relationship
  • Whether outliers are present

How to Use SigmaXL to Generate a Scatter Plot

Data File: “Scatter Plot” tab in “Sample Data.xlsx”

Steps to render a Scatterplot in SigmaXL:

  1. Select the entire range of data (both “MPG” and “weight”)
  2. Click SigmaXL -> Graphical Tools -> Scatter Plots
  3. A new window named “Scatter Plots” pops up with the selected range of data appearing in the box under “Please select your data”
  4. Click “Next>>”
  5. A new window also named “Scatter Plots” appears
  6. Select “MPG” as the “Numeric Response (Y)”
  7. Select “weight” as the “Numeric Predictor (X1)”
  8. Click “OK>>”
  9. The scatterplot appears in the new tab “Scatterplot (1)”

Model summary: The figure above is SigmaXL’s output of the scatterplot data. You can immediately see the value of graphical displays of data. This information obtainable by viewing this output shows a relationship between weight and MPG. This scatterplot shows that the heavier the weight the lower the MPG value and vice versa.

About Michael Parker

Michael Parker is the President and CEO of the Lean Sigma Corporation, a management consulting firm and online six sigma training, certification and courseware provider. Michael has over 20 years of experience leading and executing lean six sigma programs and projects. As a Fortune 50 senior executive, Michael led oversight of project portfolios as large as 150 concurrent projects exceeding $100 million in annual capital expenditures. Michael has also managed multi-site operations with the accountability of over 250 quality assurance managers, analysts, and consultants. He is an economist by education earning his Bachelor of Science degree from Radford University while also lettering 4 years as an NCAA Division I scholarship athlete. Michael earned his Six Sigma Master Black Belt certification from Bank of America and his Black Belt certification from R.R. Donnelley & Sons.

Leave a Comment