# TTEST

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content

This function returns the probability associated with a t-test.

## Syntax

TTEST(*array1*,*array2*,*tails*,*type*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *array1* | Array of values in first data set |
| *array2* | Array of values in second data set |
| *tails* | Number of tails |
| *type* | Type of t-test to perform (1, 2, or 3) |

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

`TTEST(A1:A17,B1:B17,1,3)`
`TTEST({2,2,2,3,4},{2,3,3,4,5},1,2)` gives the result 0.126036

## Version Available

This function is available in product version 1.0 or later.

## See Also

[FTEST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionFTEST) \| [TDIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionTDIST) \| [TINV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionTINV) \| [ZTEST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionZTEST) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)