TTEST

Legacy form of T.TEST.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Number

Examples

=TTEST(A1:A5, B1:B5, 2, 1)

	A	B
1	10	2
2	20	4
3	30	6
4	40	8
5	50	10

Result 0.01323559956368281

Syntax

TTEST(array1, array2, tails, type)

array1: range required
array2: range required
tails: number required
type: number required

AVEDEVAverage of absolute deviations from the mean. AVERAGE.WEIGHTEDAverage of values weighted by a second range. AVERAGEAAverages values including text and logicals. AVERAGEIFAverages cells that match a condition. AVERAGEIFSAverages cells matching multiple conditions. BETA.DISTBeta distribution.