See F.DIST.RT.
In Google Sheets, the FDIST function is a statistical function that calculates the probability of an F-distribution being less than or equal to a specified value. It is used to find the cumulative distribution function (CDF) of the F-distribution.
Here's the syntax for the FDIST function: FDIST(x, degreesfreedom1, degreesfreedom2)
x: This is the value at which you want to calculate the CDF of the F-distribution. degreesfreedom1: This is the degrees of freedom of the numerator (usually associated with the treatment or group). degreesfreedom2: This is the degrees of freedom of the denominator (usually associated with the error or residual).
The FDIST function is commonly used in hypothesis testing and analysis of variance (ANOVA) to calculate the p-value associated with a given F-statistic. By comparing the p-value to a chosen significance level, you can make decisions about rejecting or accepting the null hypothesis.