How Do I Create a Scatter Plot Matrix in Excel Using SigmaXL?
Scatter Plot Matrix
- Click Sheet 1 Tab of Customer Data.xls (or press
F4 to activate last worksheet). Click SigmaXL > Graphical Tools > Scatter Plot Matrix.
- Ensure that entire data table is selected. If not, check
Use Entire Data Table. Click Next.
- Select the variable Avg No. of orders per month; shift-click on
Staff Knowledge and click Numeric Data Variables (Y) >> as shown:
- 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.
Define, Measure, Analyze, Improve, Control