Matrix File Format
Statistica matrix files (such as Correlation, Covariances, Similarities, and Dissimilarities) can be used in the modules that support the matrix input file format.
By default, matrix spreadsheets are saved with the default file extension .smx. Most Statistica modules read both full and lower triangular matrices. However, in order for Statistica to recognize the file as a matrix file, the file must meet the following conditions:
- The number of cases (rows) = the number of variables (columns) + 4.
- The matrix must be a square matrix and the case names should be the same as the variable names.
- The last four cases contain the following case names and information:
Option Description Means The mean of each variable is given in this row; this case can be left empty (that is, do not enter anything in this row) for Similarities and Dissimilarities matrices. Std.Dev The standard deviation of each variable is given in this row; this case can be left empty (that is, do not enter anything in this row) for Similarities and Dissimilarities matrices. No.Cases This required number is the number of cases from which the matrix was produced, not the number of cases (rows of data) in this matrix file. Matrix This required number represents the type of matrix file; 1 = Correlation, 2 = Similarities, 3 = Dissimilarities, and 4 = Covariance.
Examples of lower triangular correlation matrix files:
Var 1 | Var 2 | Var 3 | |
Var 1 | 1.00 | ||
Var 2 | .20 | 1.00 | |
Var 3 | .30 | .10 | 1.00 |
Means | 12 | 11 | 10 |
Std. Dev. | 3 | 5 | 2 |
No. Cases | 50 | ||
Matrix | 1 |
For further information, see: Types of Matrices and Multiple Correlation Matrices.
Copyright © 2021. Cloud Software Group, Inc. All Rights Reserved.