What is the syntax for F.DIST in Excel?

The syntax for F.DIST is: =F.DIST(x, deg_freedom1, deg_freedom2, cumulative)

What is the CONFIDENCE.T function in Excel?

CONFIDENCE.T calculates the confidence interval for a population mean using the Student's t-distribution. It's used when sample size is small or population standard deviation is unknown.

When should I use CONFIDENCE.T instead of CONFIDENCE.NORM?

Use CONFIDENCE.T when sample size is small (<30) or when you don't know the population standard deviation. Use CONFIDENCE.NORM for large samples with known population parameters.

How do I interpret CONFIDENCE.T results?

The result is the margin of error. Add and subtract this from your sample mean to get the confidence interval. For example, if mean=100 and CONFIDENCE.T=5, the interval is 95-105.

What parameters does CONFIDENCE.T require?

CONFIDENCE.T needs: alpha (significance level, like 0.05 for 95% confidence), standard_dev (sample standard deviation), and size (sample size).

Statistical

F.DIST Function in Excel

Q: What is the F.DIST function in Excel?

Returns the F probability distribution.

Q: How do I interpret CONFIDENCE.T results?

The result is the margin of error. Add and subtract this from your sample mean to get the confidence interval. For example, if mean=100 and CONFIDENCE.T=5, the interval is 95-105.

Q: What parameters does CONFIDENCE.T require?

CONFIDENCE.T needs: alpha (significance level, like 0.05 for 95% confidence), standard_dev (sample standard deviation), and size (sample size).

Returns the F probability distribution.

Syntax

=F.DIST(x, deg_freedom1, deg_freedom2, cumulative)

Arguments

x (required): Value to evaluate
deg_freedom1 (required): Numerator degrees of freedom
deg_freedom2 (required): Denominator degrees of freedom
cumulative (required): TRUE for CDF, FALSE for PDF

Examples

=F.DIST(2, 5, 10, TRUE) - F distribution CDF - Result: 0.84

F.DIST for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

#NUM! if parameters invalid

Use cases

ANOVA
Variance comparison
Hypothesis testing

Frequently asked questions

What is the CONFIDENCE.T function in Excel? CONFIDENCE.T calculates the confidence interval for a population mean using the Student's t-distribution. It's used when sample size is small or population standard deviation is unknown.
When should I use CONFIDENCE.T instead of CONFIDENCE.NORM? Use CONFIDENCE.T when sample size is small (<30) or when you don't know the population standard deviation. Use CONFIDENCE.NORM for large samples with known population parameters.
How do I interpret CONFIDENCE.T results? The result is the margin of error. Add and subtract this from your sample mean to get the confidence interval. For example, if mean=100 and CONFIDENCE.T=5, the interval is 95-105.
What parameters does CONFIDENCE.T require? CONFIDENCE.T needs: alpha (significance level, like 0.05 for 95% confidence), standard_dev (sample standard deviation), and size (sample size).

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.