FDIST
TheFDIST
function calculates the F probability distribution. It returns the probability that the variances in two sets of data are homogeneous. This function is commonly used in hypothesis testing and regression analysis.
 How to use
FDIST
formula?  Examples of using
FDIST
formula FDIST
formula not working? Similar formulas to
FDIST
Usage
Use the FDIST
formula with the syntax shown below, it has 3 required parameters:
 x (required):
The value at which to evaluate the distribution.  degrees_freedom1 (required):
The degrees of freedom of the numerator.  degrees_freedom2 (required):
The degrees of freedom of the denominator.
Examples
Here are a few example use cases that explain how to use theFDIST
formula in Google Sheets.
Hypothesis testing
FDIST can be used to determine the probability that the variances of two sets of data are homogeneous. This is useful in hypothesis testing.
Regression analysis
FDIST can be used in regression analysis to determine if there is a significant difference between the variances of two sets of data.
Common Mistakes
FDIST
not working? Here are some common mistakes people make when using the FDIST
Google Sheets Formula:
Missing or incorrect arguments
One of the most common mistakes is not providing the correct number of arguments or providing arguments in the wrong order. Make sure to check the syntax of the FDIST formula and provide the correct arguments in the correct order.
Incorrect degrees of freedom
Another common mistake is providing incorrect degrees of freedom. Make sure to doublecheck the degrees of freedom for both the numerator and denominator and ensure that they are greater than or equal to 1.
Invalid input for x
The value of x must be greater than or equal to 0 and less than or equal to 1. Make sure to check the input for x and ensure that it meets these criteria.
Related Formulas
The following functions are similar to FDIST
or are often used with it in a formula:

FTEST
The
FTEST
function returns the result of an Ftest, which tests whether two data sets have different variances. The function takes two ranges of data as inputs and returns a probability value, which can be used to determine the likelihood that the variances of the two data sets are equal. 
TTEST
The
TTEST
formula is a statistical formula used to determine the probability of two sample means being equal. It is commonly used in hypothesis testing to determine if there is a significant difference between two sets of data. The formula returns the probability value associated with a ttest, which can be used to determine if the null hypothesis should be rejected or not. 
CHIDIST
The
CHIDIST
function calculates the onetailed probability of the chisquared distribution. It is commonly used in hypothesis testing to determine whether there is a significant difference between expected and observed values in a contingency table or to test the goodness of fit of an observed distribution to a theoretical distribution.
Learn More
You can learn more about the FDIST
Google Sheets function on Google Support.