Functions
F.DIST
F CDF/PDF
Try it
When to use it
When should I use F.DIST?
Use F.DIST to compute the F-distribution cumulative probability (TRUE) or probability density (FALSE) when comparing the variance ratio of two data sets, such as in ANOVA or regression analysis.
Used in
Syntax
F.DIST(x,df1,df2,cumulative)Examples
=F.DIST(15.35,7,6,TRUE) // => 0.9980694465675399
=F.DIST(15.35,7,6,FALSE) // => 0.0003451054686025562