What Is a Matrix Spreadsheet?
A STATISTICA Matrix Spreadsheet (*.smx) is a spreadsheet file with a strictly defined format that can be used as input in several modules of STATISTICA (e.g., Cluster Analysis, Multidimensional Scaling, SEPATH). Matrix spreadsheets have to meet the following conditions: 1. The number of cases (rows) = the number of variables (columns) + 4. 2. The matrix must be a square matrix and the case names should be the same as the variable names. 3. The last four cases contain the following case names and information: Means: The mean of each variable is given in this row; this case can be left empty (i.e., 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 (i.e., do not enter anything in this row) for Similarities and Dissimilarities matrices. No.Cases: This required entry is the number of cases from which the matrix was produced, not the number of cases (rows of dat
