Include Top

Home | Login | Live Help is Live Help

Included Menu

How Do I Create a Scatter Plot Matrix in Excel Using SigmaXL?

Scatter Plot Matrix

  1. Click Sheet 1 Tab of Customer Data.xls (or press F4 to activate last worksheet). Click SigmaXL > Graphical Tools > Scatter Plot Matrix.
  2. Ensure that entire data table is selected. If not, check Use Entire Data Table. Click Next.
  3. Select the variable Avg No. of orders per month; shift-click on Staff Knowledge and click Numeric Data Variables (Y) >> as shown:
  4. Scatter Plot Matrix

  1. Click OK. Resulting Scatter Plot Matrix:

  2. SigmaXL Scatter Plot Matrix
    Of particular interest is Overall Satisfaction versus Responsiveness to Calls and Ease of Communications. These will be explored further with Multiple Linear Regression.

Click here to download a Free 30-Day Trial.