T.TEST (PQL - xl)

This function returns the probability associated with a t-test

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

T.TEST(array1, array2, tails, type)

Function Arguments

Name

Description

Type

Optional

array1

Array of values in first data set

StringOrNumber

array2

Array of values in 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 'T.TEST' function - using the same inputs, logic and outputs.