F.DIST function is a built-in statistical function that returns the F – probability distribution. It takes the 3 arguments with the type of distribution function. In this post, we will explain to you how to use the F.DIST Function In Excel Office 365. Let’s see them below!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
F.DIST Function syntax
=F.DIST(x, deg_freedom1, deg_freedom2, cumulative)
Syntax Explanation:
- x : value at which to evaluate the function.
- deg_freedom1 : numerator degrees of freedom.
- deg_freedom2 : denominator degrees of freedom.
- cumulative : logical value that determines the form of the function. If cumulative is TRUE, F.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
Example
- Firstly, you need to create the sample data with x value with given two degrees of freedom.
- Then, you have to calculate the cumulative f – distribution function.
- Now, you need to use the following formula given below.
=F.DIST ( B2, B3, B4, FALSE)
- After that, you can find out the probability value for the f distribution function for the value at least 5 following the same parameters with the formula shown below.
=F.DIST ( B2, B3, B4, TRUE)
- F-distribution is a method of obtaining the probabilities of specific sets of events occurring.
- F-statistic is often used to assess the significant difference of a theoretical model of the data.
- At last, once the F-statistic is calculated , you have to compare the value to a table of critical values that serve as minimum cutoff values for significance.
NOTE:
- The F.DIST Function only works with numbers.
- If any argument other than cumulative is non-numeric , the function returns #VALUE! error.
- The function returns #NUM! Error.
- If x is negative
- If the deg_freedom1 is < 1 or >10^10.
- If the deg_freedom2 is < 1 or >10^10.
- Then, the argument deg_freedom1 or deg_freedom2 are truncated to integer if not.
- Now, the cumulative argument can be used with boolean numbers (0 and 1) or (FALSE or TRUE).
- After that, the value in decimal and value in percentage id the same value in Excel and convert the value to percentage , if required.
- Finally, you can feed the arguments to the function directly or using the cell reference, as explained in the example.
Wrap-Up
Hope you understood how to use the F.DIST Function In Excel Office 365. Please feel free to state your query or feedback for the above article. Thank you so much for Reading!! To learn more, check out Geek Excel!! *and Excel Formulas *!!
Read Ahead:
Top comments (0)