Hi Luis,
Here is probably the least script involved procedure for many matrices to calculate
the mean and SE at each cell position:
We assume that all matrices are stored in matrix objects in a matrix sheet in a matrix.
1) "Matrix Set Dimension/Labels" menu. Change the matrix size with 1 column and NxM rows,
e.g., when originally 8 columns by 6 rows, you set them as 1 column by 48 rows.
Also, turn ON "Rearranged" radio button for "Data will be" option.
==> Every matrix becomes 1-column format.
2) Run the following script to copy all matrices into the columns in a worksheet:
(In this sample, the matrix is in MBook1, worksheet is in Book1) for(ii=1; ii<=MBook1!wks.nmats; ii++) {
range mm=[MBook1]1!$(ii);
range ww=[Book1]1!wcol(ii);
ww=mm;
}3) Highlight all columns in the worksheet, and seelect "Statistics: Descriptive Stats: Stats on Rows" menu.
Turn ON Mean and SE of mean check boxes under Quantities to Compute branch.
4) Add 2 new matrix objects in the matrix, and copy-and-paste the Mean column into the first added matrix object.
Do the same for the the SE column.
5) Reconvert the matrices back to NxM dimensions - select "Matrix Set Dimension/Labels" menu,
turn ON "Rearranged" radio button for "Data will be" option.
Note that one matrix sheet in a matrix book can contain 65527 matrix objects!
--Hideo Fujii
OriginLab
Average and SEM in Matrix
Posted - 10/03/2015 : 11:00:53 AM
