TTEST (PQL - xl)

This function returns the probability associated with a t-test

Syntax

TTEST(array1, array2, tails, type)

Function Arguments

Name

Description

Type

Optional

array1

Array of values in the first data set

StringOrNumber

array2

Array of values in the second data set

StringOrNumber

tails

Number of tails

Number

type

Type of t-test to perform (1, 2, or 3)

Number

Comments

This function is the same as the Microsoft Excel 'TTEST' function - using the same inputs, logic and outputs.