Documentation/Calc Functions/TTEST

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

TTEST

Category:

Statistical Analysis

Summary:

Returns the probability associated with a Student's t-Test.

Syntax:

TTEST(Data1; Data2; Mode; Type)

Returns:

Arguments:

Data1 is the dependent array or range of data for the first record.

Data2 is the dependent array or range of data for the second record.

Mode = 1 calculates the one-tailed test, Mode = 2 the two- tailed test.

Type is the kind of t-test to perform. Type 1 means paired. Type 2 means two samples, equal variance (homoscedastic). Type 3 means two samples, unequal variance (heteroscedastic).

Additional details:

Examples:

=TTEST(A1:A50;B1:B50;2;2)

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: