Navigation:  Formula Reference > Spreadsheet Formula Functions >

T.TEST

Previous pageReturn to chapter overviewNext page

 

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

Syntax

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

Remarks

The tails and type arguments are truncated to integers. The #VALUE! error value is returned if tails or type is nonnumeric.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

T.TEST(A1:A17,B1:B17,4,3)

T.TEST({2,2,2,3,4},{2,3,3,4,5},1,2) gives the result 0.1260360000000153