Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
574

Multivariate Analyses

Correlation Matrix


The StatPlus>Multivariate Analysis>Correlation Matrix command creates
a correlation matrix for data arranged in different columns. The correlation
matrix can use either the Pearson correlation coeffi cient or the nonparamet-
ric Spearman rank correlation coeffi cient. You can also output a matrix of
p values for the correlation matrix.

Means Matrix


The StatPlus>Multivariate Analysis>Means Matrix command creates a ma-
trix of pairwise mean differences for data. The data values can be arranged in
Free download pdf