UNISTAT - the ultimate Excel statistics add-in

Matrix Statistics in Excel with Unistat

The Unistat statistics add-in extends Excel with Matrix Statistics capabilities.

Further documentation is available at section 7.1 of the manual, Matrix Statistics.

Sample output

Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.

Matrix Statistics

Descriptive Statistics

Subsample selected by: Period = 1
Valid Number of Cases: 8, 8 Omitted

AVGSTDSERVARSUMSSQMINMAX
AUC 205.6250 58.8386 20.8026 3461.9821 1645.0000 362487.0000 133.0000 294.0000
Sequence = AB 0.5000 0.5345 0.1890 0.2857 4.0000 4.0000 0.0000 1.0000
Treatment = A 0.5000 0.5345 0.1890 0.2857 4.0000 4.0000 0.0000 1.0000
Sequence × Treatment = AB × A 0.5000 0.5345 0.1890 0.2857 4.0000 4.0000 0.0000 1.0000

Correlation Matrix

AUCSequence = ABTreatment = ASequence × Treatment = AB × A
AUC 1.0000 0.5292 0.5292 0.5292
Sequence = AB 0.5292 1.0000 1.0000 1.0000
Treatment = A 0.5292 1.0000 1.0000 1.0000
Sequence × Treatment = AB × A 0.5292 1.0000 1.0000 1.0000

Covariance Matrix

AUCSequence = ABTreatment = ASequence × Treatment = AB × A
AUC 3461.9821 16.6429 16.6429 16.6429
Sequence = AB 16.6429 0.2857 0.2857 0.2857
Treatment = A 16.6429 0.2857 0.2857 0.2857
Sequence × Treatment = AB × A 16.6429 0.2857 0.2857 0.2857

Moment Matrix

AUCSequence = ABTreatment = ASequence × Treatment = AB × A
AUC 45310.8750 117.3750 117.3750 117.3750
Sequence = AB 117.3750 0.5000 0.5000 0.5000
Treatment = A 117.3750 0.5000 0.5000 0.5000
Sequence × Treatment = AB × A 117.3750 0.5000 0.5000 0.5000

Data Matrix

AUCSequence = ABTreatment = ASequence × Treatment = AB × A
1 290.0000 1.0000 1.0000 1.0000
****
3 163.0000 0.0000 0.0000 0.0000
****
5 187.0000 1.0000 1.0000 1.0000
****
7 168.0000 1.0000 1.0000 1.0000
****
9 220.0000 0.0000 0.0000 0.0000
****
11 133.0000 0.0000 0.0000 0.0000
****
13 294.0000 1.0000 1.0000 1.0000
****
15 190.0000 0.0000 0.0000 0.0000
****

Descriptive Statistics

Subsample selected by: Period = 2
Valid Number of Cases: 8, 8 Omitted

AVGSTDSERVARSUMSSQMINMAX
AUC 149.0000 50.8331 17.9722 2584.0000 1192.0000 195696.0000 77.0000 210.0000
Sequence = AB 0.5000 0.5345 0.1890 0.2857 4.0000 4.0000 0.0000 1.0000
Treatment = A 0.5000 0.5345 0.1890 0.2857 4.0000 4.0000 0.0000 1.0000
Sequence × Treatment = AB × A 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000

Correlation Matrix

AUCSequence = ABTreatment = ASequence × Treatment = AB × A
AUC 1.0000-0.2787 0.2787*
Sequence = AB-0.2787 1.0000-1.0000*
Treatment = A 0.2787-1.0000 1.0000*
Sequence × Treatment = AB × A*** 1.0000

Covariance Matrix

AUCSequence = ABTreatment = ASequence × Treatment = AB × A
AUC 2584.0000-7.5714 7.5714 0.0000
Sequence = AB-7.5714 0.2857-0.2857 0.0000
Treatment = A 7.5714-0.2857 0.2857 0.0000
Sequence × Treatment = AB × A 0.0000 0.0000 0.0000 0.0000

Moment Matrix

AUCSequence = ABTreatment = ASequence × Treatment = AB × A
AUC 24462.0000 67.8750 81.1250 0.0000
Sequence = AB 67.8750 0.5000 0.0000 0.0000
Treatment = A 81.1250 0.0000 0.5000 0.0000
Sequence × Treatment = AB × A 0.0000 0.0000 0.0000 0.0000

Data Matrix

AUCSequence = ABTreatment = ASequence × Treatment = AB × A
****
2 210.0000 1.0000 0.0000 0.0000
****
4 201.0000 0.0000 1.0000 0.0000
****
6 116.0000 1.0000 0.0000 0.0000
****
8 77.0000 1.0000 0.0000 0.0000
****
10 200.0000 0.0000 1.0000 0.0000
****
12 151.0000 0.0000 1.0000 0.0000
****
14 140.0000 1.0000 0.0000 0.0000
****
16 97.0000 0.0000 1.0000 0.0000


DownloadUnistat 6.0
For Windows