F.TEST (PQL - xl)

This function returns the result of an F-test, which returns the two-tailed probability that the variances in two arrays are not significantly different

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

Syntax

F.TEST(array1, array2)

Function Arguments

Name

Description

Type

Optional

array1

The arguments may be array of values

StringOrNumber

array2

The arguments may be array of values

StringOrNumber

Comments

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