UNISTAT - the ultimate Excel statistics add-in

6.1.3. Parametric Tests Matrix

This procedure will compute the four most commonly used Parametric Tests (pooled and separate variance t-tests and classical and Levene’s F-Tests) for all pairs of selected variables.

Parametric Tests Matrix

The Variable Selection Dialogue is of the multisample type (see 6.0.4. Multisample Tests), allowing selection of multiple variables and factors. It is possible to perform tests between variables in separate columns, as well as between the groups defined by levels of factor columns.

The output is in the form of a matrix in each cell of which the test statistic, its degrees of freedom and the tail probability are displayed for up to four tests. The tests to be performed can be selected from the Output Options Dialogue.

In earlier versions of UNISTAT, two-tailed probabilities were reported for t-tests and one-tail probability for the F-test. As of this version, you can choose to display one- or two-tailed probabilities for all test statistics.

Example

Open DEMODATA and select Statistics 1Parametric Tests → 6.1.3. Parametric Tests Matrix. Select Wages, Energy, Interest and Fixed capital (C2 to C5) as [Variable]s and check all three options at the Output Options Dialogue to obtain the following results:

Parametric Tests Matrix

 

Wages

 

 

Energy

 

 

 

Test

DoF

2-Tail P

Test

DoF

2-Tail P

Wages t-Pl

 

 

 

 0.3079

 112.0000

 0.7588

t-Sp

 

 

 

 0.3079

 110.5460

 0.7588

F-

 

 

 

 1.2591

 56.0000

 0.1957

F-Lv

 

 

 

 1.9049

 56.0000

 0.1703

Energy t-Pl

 0.3079

 112.0000

 0.7588

 

 

 

t-Sp

 0.3079

 110.5460

 0.7588

 

 

 

F-

 1.2591

 56.0000

 0.1957

 

 

 

F-Lv

 1.9049

 56.0000

 0.1703

 

 

 

Interest t-Pl

 7.4684

 113.0000

 0.0000

 6.6811

 113.0000

 0.0000

t-Sp

 7.4634

 112.0421

 0.0000

 6.6701

 108.4311

 0.0000

F-

 1.1621

 56.0000

 0.2868

 1.4632

 56.0000

 0.0776

F-Lv

 0.8365

 56.0000

 0.3624

 5.2207

 56.0000

 0.0242

Fixed Capital t-Pl

 7.4734

 113.0000

 0.0000

 6.6840

 113.0000

 0.0000

t-Sp

 7.4683

 111.9722

 0.0000

 6.6728

 108.2920

 0.0000

F-

 1.1699

 56.0000

 0.2783

 1.4731

 56.0000

 0.0740

F-Lv

 0.7881

 56.0000

 0.3766

 5.1776

 56.0000

 0.0248

 

 

Interest

 

 

Fixed Capital

 

 

 

Test

DoF

2-Tail P

Test

DoF

2-Tail P

Wages t-Pl

 7.4684

 113.0000

 0.0000

 7.4734

 113.0000

 0.0000

t-Sp

 7.4634

 112.0421

 0.0000

 7.4683

 111.9722

 0.0000

F-

 1.1621

 56.0000

 0.2868

 1.1699

 56.0000

 0.2783

F-Lv

 0.8365

 56.0000

 0.3624

 0.7881

 56.0000

 0.3766

Energy t-Pl

 6.6811

 113.0000

 0.0000

 6.6840

 113.0000

 0.0000

t-Sp

 6.6701

 108.4311

 0.0000

 6.6728

 108.2920

 0.0000

F-

 1.4632

 56.0000

 0.0776

 1.4731

 56.0000

 0.0740

F-Lv

 5.2207

 56.0000

 0.0242

 5.1776

 56.0000

 0.0248

Interest t-Pl

 

 

 

-0.0070

 114.0000

 0.9945

t-Sp

 

 

 

-0.0070

 113.9987

 0.9945

F-

 

 

 

 1.0068

 57.0000

 0.4899

F-Lv

 

 

 

 0.0015

 57.0000

 0.9689

Fixed Capital t-Pl

-0.0070

 114.0000

 0.9945

 

 

 

t-Sp

-0.0070

 113.9987

 0.9945

 

 

 

F-

 1.0068

 57.0000

 0.4899

 

 

 

F-Lv

 0.0015

 57.0000

 0.9689