Documentation/Calc Functions/TTEST

Function name:
TTEST

Category:
Statistical Analysis

Summary:
Calculates the probability associated with a Student's t-test. The function gives the p-value of a 2-sample t-test.

Syntax:
TTEST(Data1; Data2; Mode; Type)

Returns:
Returns a real number which is the probability associated with a Student's t-Test for the given arguments. It returns values in the range [0,1].

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 to perform a one-tailed test, Mode = 2 to perform a 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).


 * If Mode is less than 1 or greater than or equal to 3 then the function returns an error value.
 * If Mode or Type is a non-integer value then the function uses its floor value, i.e. it is truncated to an integer.
 * If Type is less than 1 or greater than or equal to 4 then the function returns an error value.
 * If the dimensions of Data1 and Data2 are different, then the function returns an error value.

Additional details:

 * For more details on Student's t-Test, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/T.DIST T.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/T.DIST.2T T.DIST.2T]

[[Special:MyLanguage/Documentation/Calc_Functions/T.DIST.RT T.DIST.RT]

[[Special:MyLanguage/Documentation/Calc_Functions/T.INV T.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/T.INV.2T T.INV.2T]

[[Special:MyLanguage/Documentation/Calc_Functions/T.DIST T.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/TINV TINV]

[[Special:MyLanguage/Documentation/Calc_Functions/T.TEST T.TEST]

ODF standard:
None

Equivalent Excel functions:
TTEST