Meaning of the keyword: what is f.dist.rt function
The keyword what is f.dist.rt function refers to the spreadsheet function F.DIST.RT(x, df1, df2), which returns a right-tail probability for an F distribution. In statistical terms, it evaluates the survival function \(P(F \ge x)\) for a random variable \(F\) that follows an \(F(df_1, df_2)\) distribution.
Definition in statistical notation
\[ \text{F.DIST.RT}(x,df_1,df_2)=P\!\left(F \ge x\right)\quad \text{where}\quad F \sim F(df_1,df_2) \]
This is the probability in the right tail beyond the observed value \(x\). For F-tests (including one-way ANOVA), this right-tail probability is commonly the p-value.
Arguments and required conditions
| Argument | Meaning | Typical statistical role | Valid range |
|---|---|---|---|
| x | The F-value at which the right-tail probability is evaluated | Observed test statistic \(F_{\text{obs}}\) | \(x \ge 0\) |
| df1 | Numerator degrees of freedom | Often \(k-1\) in one-way ANOVA | \(df_1 > 0\) |
| df2 | Denominator degrees of freedom | Often \(N-k\) in one-way ANOVA | \(df_2 > 0\) |
The order of degrees of freedom matters: swapping \(df_1\) and \(df_2\) changes the distribution and therefore changes the probability.
Relationship to the left-tail F distribution function
Many spreadsheets also provide a left-tail cumulative distribution function (CDF), which gives \(P(F \le x)\). The right-tail probability is the complement of the CDF:
\[ P(F \ge x)=1-P(F \le x) \]
\[ \text{F.DIST.RT}(x,df_1,df_2)=1-\text{F.DIST}(x,df_1,df_2,\text{TRUE}) \]
Worked example: using F.DIST.RT as an F-test p-value
Suppose an F-test (for example, a one-way ANOVA) produces an observed statistic \(F=4.21\) with numerator degrees of freedom \(df_1=2\) and denominator degrees of freedom \(df_2=12\). The right-tail p-value is:
\[ p = P\!\left(F(2,12)\ge 4.21\right) = \text{F.DIST.RT}(4.21,2,12) \]
\[ p \approx 0.0412 \]
Since \(p \approx 0.0412\) is less than \(0.05\), the result is statistically significant at \(\alpha=0.05\) (right-tailed F-test decision rule).
Visualization: right-tail probability returned by F.DIST.RT
Common interpretation errors
- Confusing right tail with left tail: F-tests are typically right-tailed; the p-value is \(P(F \ge F_{\text{obs}})\), not \(P(F \le F_{\text{obs}})\).
- Swapping degrees of freedom: \(F(df_1,df_2)\) is not symmetric in \(df_1\) and \(df_2\).
- Using \(x<0\): the F distribution is supported on \([0,\infty)\), so negative \(x\) values are not meaningful for this probability.