SheetFX
≡
<< Go back to all functions

FDIST

The FDIST function in Google Sheets calculates the F probability distribution. It returns the probability that the variances in the dataset are significantly different from each other. This statistical function is widely used in hypothesis testing and analysis of variance (ANOVA).

Function Syntax and Parameters

Syntax: FDIST(x, degrees_freedom1, degrees_freedom2)

Parameters:

  • x: The value at which you want to evaluate the distribution.
  • degrees_freedom1: The number of degrees of freedom in the numerator.
  • degrees_freedom2: The number of degrees of freedom in the denominator.

Step-by-Step Tutorial

  1. Calculating F distribution probability:
    • Example: =FDIST(2.5, 3, 8)
    • Result: Returns the probability of F distribution at the value 2.5, with 3 degrees of freedom in the numerator and 8 degrees of freedom in the denominator.

Use Cases and Scenarios

  1. Hypothesis Testing: Determine if the variances in two datasets are significantly different.
  2. Analysis of Variance (ANOVA): Assess the variability between multiple groups or treatments.

Related Functions

  • F.DIST.RT: Returns the F probability distribution, given the value at which to evaluate it and the degrees of freedom.
  • F.INV.RT: Returns the inverse of the F probability distribution, given a probability and the degrees of freedom.

Related Articles