Matrix Node Appearance Tab
The Appearance tab enables you to control sorting and highlighting options for the matrix, as well as statistics presented for cross-tabulation matrices.
Rows and columns. Controls the sorting of row and column headings in the matrix. The default is Unsorted. Select Ascending or Descending to sort row and column headings in the specified direction.
Overlay. Enables you to highlight extreme values in the matrix. Values are highlighted based on cell counts (for cross-tabulation matrices) or calculated values (for function matrices).
- Highlight top. You can request the highest values in the matrix to be highlighted (in red). Specify the number of values to highlight.
- Highlight bottom. You can also request the lowest values in the matrix to be highlighted (in green). Specify the number of values to highlight.
Note: For the two highlighting options, ties can cause more values than requested to be highlighted. For example, if you have a matrix with six zeros among the cells and you request Highlight bottom 5, all six zeros will be highlighted.
Cross-tabulation cell contents. For cross-tabulations, you can specify the summary statistics contained in the matrix for cross-tabulation matrices. These options are not available when either the All Numerics or Function option is selected on the Settings tab.
- Counts. Cells include the number of records with the row value that have the corresponding column value. This is the only default cell content.
-
Expected values. The expected value for number of records in the cell, assuming that there is
no relationship between the rows and columns. Expected values are based on the following formula:
p(row value) * p(column value) * total number of records
- Residuals. The difference between observed and expected values.
- Percentage of row. The percentage of all records with the row value that have the corresponding column value. Percentages sum to 100 within rows.
- Percentage of column. The percentage of all records with the column value that have the corresponding row value. Percentages sum to 100 within columns.
- Percentage of total. The percentage of all records having the combination of column value and row value. Percentages sum to 100 over the whole matrix.
- Include row and column totals. Adds a row and a column to the matrix for column and row totals.
- Apply Settings. (Output Browser only) Enables you to make changes to the appearance of the Matrix node output without having to close and reopen the Output Browser. Make the changes on this tab of the Output Browser, click this button and then select the Matrix tab to see the effect of the changes.