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. Click OK. Resulting 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.