[]

Document Solutions for Excel, Java Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
  - BETADIST
  - BETAINV
  - BINOMDIST
  - CHIDIST
  - CHIINV
  - CHITEST
  - CONFIDENCE
  - COVAR
  - CRITBINOM
  - EXPONDIST
  - FDIST
  - FINV
  - FLOOR
  - FTEST
  - GAMMADIST
  - GAMMAINV
  - HYPGEOMDIST
  - LOGINV
  - LOGNORMDIST
  - MODE
  - NEGBINOMDIST
  - NORM.INV
  - NORMDIST
  - NORMSDIST
  - NORMSINV
  - PERCENTILE
  - PERCENTRANK
  - POISSON
  - QUARTILE
  - RANK
  - STDEV
  - STDEVP
  - TDIST
  - TINV
  - TTEST
  - VAR
  - VARP
  - WEIBULL
  - ZTEST
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Use JDK 8 Date Time API
Document Solutions Data Viewer
API Reference
Release Notes

TTEST

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	[Required] Array of values in the first data set
array2	[Required] Array of values in the second data set
tails	[Required] Specifies the number of distribution tails. If tails = 1, TTEST uses the one-tailed distribution. If tails = 2, TTEST uses the two-tailed distribution
type	[Required] Type of t-test to perform (1, 2, or 3)

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