A scatter matrix is a pair-wise scatter plot of several variables presented in a matrix format. It can be used to determine whether the variables are correlated and whether the correlation is positive or negative.
To create a scatter matrix:
Each selected column (or a range of it) is plotted against every other selected column (or a range of it) as a scatter plot layer and all layers are presented in a matrix format in the graph.
You can use its dialog to control the creation of the scatter matrix.
Specify the grouping range. The scatters will be colored by the level in the grouping range.
The matrix format can be one of three arrangements
Specify whether to display the long name of columns from source data.
The way of tick and labels arrangement can be one of the options below
Specify whether to show gap between each layer. Type a value in the box to control the spacing between the layers in units of % of the width.
If this is checked, a confidence ellipse will be drawn for each graph based on the chosen confidence level.
Perform a linear fit to each pair of variables.
Specify whether to exclude missing values (listwise). That is, exclude the entire row for all datasets if there are any missing values in this row.
This determines where the calculated data for the ellipse and the fit are stored. The default location is a new worksheet (<new>) within the source workbook ([<input>]).
Note: selecting N datasets or ranges will result in N^2-N graphs and an even larger number of datasets. Selecting a large number of datasets or ranges may increase the computation time dramatically and produce small graphs.