Returns the probability associated with t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean.

Sample Usage

TTEST(A1:A4, B1:B4, 2, 1)


TTEST(range1, range2, tails, type)

  • range1 - The first sample of data or group of cells to consider for the t-test.

  • range2 - The second sample of data or group of cells to consider for the t-test.

  • tails - Specifies the number of distribution tails.

    • If 1: uses a one-tailed distribution.

    • If 2: uses a two-tailed distribution.

  • type - Specifies the type of t-Test.

    • If 1: a paired test is performed.

    • If 2: a two-sample equal variance (homoscedastic) test is performed.

    • If 3: a two-sample unequal variance (heteroscedastic) test is performed.


  • tails and type must be numeric.

  • range1 and range2 must have the same number of data points.

  • TTEST uses the data in range1 and range2 to compute a non-negative test. If tails is set to 1TTEST returns the probability of a higher value of the t-statistic under the assumption that range1 and range2 are samples from populations with the same mean. The value returned by TTEST when tails is set to 2 is double that returned whentails is set to 1 and corresponds to the probability of a higher absolute value of the t-statistic under the "same population means" assumption.

In order to use the TTEST formula, start with your edited Excellentable:

Then type in the TTEST formula in the area you would like to display the outcome:

By adding the values you would like to calculate the TTEST formula for, Excellentable will generate the outcome:



User does not have sufficient privileges to access this Content
Learn More