FTEST (PQL - xl)

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

Syntax

FTEST(array1, array2)

Function Arguments

Name

Description

Type

Optional

array1

The arguments may be arrays of values

StringOrNumber

array2

The arguments may be arrays of values

StringOrNumber

Comments

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