 # How To Use FDIST()

Description

See F.DIST.RT

Common questions about the FDIST formula include:
- What is the formula?
- What are the parameters of the formula?
- How do the parameters shape the output?

The FDIST formula can be used appropriately to calculate the probability of observing a specific outcome in a normal distribution. The parameters that need to be considered are the number of standard deviations from the mean (x_value) the outcome is located, the mean (mu) of the distribution, and the standard deviation (sigma) of the distribution.

Common ways the FDIST formula can be mistyped include using incorrect symbols or numbering in the formula, reversing x-value and mu, or forgetting to include sigma.

Some common ways the FDIST formula can be used inappropriately include using the formula when the data are not normally distributed, using the wrong parameters for the formula, or using the formula to calculate the probability of a given range of outcome.

Common pitfalls when using the FDIST formula include using the formula when the data are not normally distributed, mistyping the formulae, and using the wrong parameters for the formula.

Common mistakes when using the FDIST formula include forgetting to use the sigma parameter, mistyping the symbols or parameters, and using the wrong parameters for the formula.

Common misconceptions people might have with the FDIST Formula include thinking the formula can be used for non-normal distributions or that the formula will give an exact probability rather than a close estimate.

How To Actually Use FDIST() in Sheets

`FDIST(x, degrees_freedom1, degrees_freedom2)`

0Better Sheets Tutorials

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.

SOCY201-Using Google Sheets to Solve a Simple, Oneway ANOVA Problem

ANOVA problems can be solved using a spreadsheet and this video shows how to use Google sheets to do this. Beside showing how to set up and solve for the F-statistic, some tips like using named ranges, absolute addresses, and some interesting spreadsheet functions are explained.

Better Sheets