Formualizer Docs
ReferenceFunctionsStatistics Functions

F.TEST

F.TEST: Returns the two-tailed p-value from an F-test comparing sample variances.

Summary

F.TEST evaluates whether two samples have significantly different variances.

Remarks

  • Each array must contain at least two numeric values.
  • Uses sample variances and computes a two-tailed probability.
  • Returns #DIV/0! when either sample variance is zero.
  • Alias FTEST is supported.

Examples

Identical samples yield p-value 1
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Different variances example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.5466810975407987

Runtime metadata

Category

Statistics

Signature

F.TEST(arg1: Number (Range), arg2: Number (Range))

Arity

min 2, max 2

Arguments

arg1

Number · Range · coercion NumberLenientText

arg2

Number · Range · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

F.INV

F.INV: Returns the F value whose left-tail probability equals `probability`.

FISHER

Returns the Fisher z-transformation of a correlation-like value `x`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata