F.DIST.RT Function in Excel: F Test p-Value (Right Tail)

F.DIST.RT Function in Excel: F Test p-Value (Right Tail) 1
⏱ 1 min readUpdated 5 October 2026

StatisticsLevel: ExpertAvailable in: Excel 2010+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. F.DIST.RT in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

F.DIST.RT turns an F statistic (from ANOVA or a variance ratio) into a p-value.

Advertisement

Syntax

=F.DIST.RT(x, deg_freedom1, deg_freedom2)
Argument What it means
x F statistic
df1, df2 Degrees of freedom

Examples

Example 1

=ROUND(F.DIST.RT(A2,B2,C2),4)

Result: 0.0888. See the worked example table below for more cases.

F.DIST.RT in practice

Where you will use it

  • ANOVA p-values
  • Comparing machine consistency
  • Regression significance

Worked example

Fdf1df2FormulaResult
2.5320=ROUND(F.DIST.RT(A2,B2,C2),4)0.0888
1510=ROUND(F.DIST.RT(A3,B3,C3),4)0.4651
4230=ROUND(F.DIST.RT(A4,B4,C4),4)0.0288

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
df in the wrong orderNumerator df first
Reading pBelow 0.05 = significant difference

F.INV.RT · F.TEST

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZCONFIDENCE.T Function in Excel: Margin of Error for Small SamplesExcel Functions A–ZPERCENTRANK.EXC Function in Excel: Percentile Position, Excluding EndsExcel Functions A–ZERROR.TYPE Function in Excel: Which Error Is It?
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong