[]

SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
    - BETADIST
    - BETAINV
    - BINOMDIST
    - CHIDIST
    - CHIINV
    - CHITEST
    - CONFIDENCE
    - COVAR
    - CRITBINOM
    - EXPONDIST
    - FDIST
    - FLOOR
    - FTEST
    - GAMMADIST
    - GAMMAINV
    - HYPGEOMDIST
    - LOGINV
    - LOGNORMDIST
    - MODE
    - NEGBINOMDIST
    - NORM.INV
    - NORMDIST
    - NORMSDIST
    - NORMSINV
    - PERCENTILE
    - PERCENTRANK
    - POISSON
    - QUARTILE
    - RANK
    - STDEV
    - STDEVP
    - TDIST
    - TINV
    - TTEST
    - VAR
    - VARP
    - WEIBULL
    - ZTEST
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
  - Financial Functions
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
  - Web Functions
  - Other Functions
  - RegEx Functions
Import and Export Reference
Frequently Used Events
API Documentation
Release Notes

FDIST

This function calculates the F probability distribution, to see degrees of diversity between two sets of data.

Syntax

FDIST( value, degnum, degden )

Arguments

This function has these arguments:

Argument	Description
value	Value at which to evaluate the function
degnum	Number of degrees of freedom for the numerator; if not an integer, the number is truncated
degden	Number of degrees of freedom for the denominator; if not an integer, the number is truncated

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

FDIST(A1,2,2)

FDIST(R1C1,2,1)

FDIST(16.83975,5,3) gives the result 0.021