# Documentation/Calc Functions/T.TEST

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

T.TEST

## 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:

T.TEST(**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.

## Examples:

Data1 | Data2 | |
---|---|---|

1 | 195 | 200 |

2 | 151 | 180 |

3 | 148 | 178 |

4 | 189 | 165 |

5 | 183 | 192 |

6 | 154 | 144 |

Formula | Description | Returns |
---|---|---|

=T.TEST(A1:A6;B1:B6;1.5;2.9) | The function calculates the Student's t-test for the given data passed as reference to a list of cells. Here Mode and Type are both non-integer values and get truncated to integers 1 and 2, respectively. |
0.298513332513432 |

=T.TEST({8,9,10,11};{50,80,110,140};2.5;3.9) | The function calculates the Student's t-test for the given data passed as reference to a list of cells. Here Mode and Type are both non-integer values and get truncated to integers 2 and 3, respectively. |
0.021495566698816 |

=T.TEST(A1:A6;B1:B6;1.5;4) | The function will return an error value since Type is greater than or equal to 4. |
Err:502 |

## Related LibreOffice functions:

## ODF standard:

None

## Equivalent Excel functions:

T.TEST