How to use the F.DIST function in Excel office 365?
Tags: tousethefdistfunctio, excel, excelfunctions
Published: 2021-08-23 06:17:48

---
title: How to use the F.DIST function in Excel office 365?
published: true
date: 2021-08-17 18:07:14 UTC
tags: ToUseTheFDISTFunctio,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-f-dist-function-in-excel-office-365/
---

 **F.DIST function** is a **built-in statistical** function that returns the **F – probability distribution**. It takes the **3 arguments** with the type of distribution function. In this post, we will explain to you how to **use the F.DIST Function In Excel Office 365.** Let’s see them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## F.DIST Function syntax

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

**Syntax Explanation:**

- x : value at which to evaluate the function.
- deg\_freedom1 : numerator degrees of freedom.
- deg\_freedom2 : denominator degrees of freedom.
- cumulative : logical value that determines the form of the function. If cumulative is TRUE, F.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

## Example

- Firstly, you need to **create the sample data** with **x value** with given **two degrees of freedom**.

![](https://geekexcel.com/wp-content/uploads/2021/08/sample-data-3.png)<figcaption>Sample data</figcaption>

- Then, you have to calculate the **cumulative f –  distribution** function.
- Now, you need to use the following **formula** given below.

```
=F.DIST ( B2, B3, B4, FALSE)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/cumulative-distribution-2-1024x196.png)<figcaption>cumulative distribution</figcaption>

- After that, you can find out the **probability value** for the **f distribution** function for the **value at least 5** following the **same parameters** with the formula shown below.

```
=F.DIST ( B2, B3, B4, TRUE)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/probability-mass-distribution-3-1024x194.png)<figcaption>probability mass distribution</figcaption>

- **F-distribution** is a method of obtaining the **probabilities of specific sets of events** occurring.
- **F-statistic** is often used to assess the **significant difference** of a **theoretical model of the data**.
- At last, once the **F-statistic is calculated** , you have to compare the **value to a table of critical values** that serve as minimum cutoff values for significance.

**NOTE:**

- The F.DIST Function only works with **numbers**.
- If any **argument** other than **cumulative is non-numeric** , the function **returns #VALUE! error**.
- The **function returns #NUM! Error**.
  - If x is negative
  - If the deg\_freedom1 is < 1 or >10^10.
  - If the deg\_freedom2 is < 1 or >10^10.
- Then, the **argument deg\_freedom1** or **deg\_freedom2** are **truncated** to **integer if not**.
- Now, the **cumulative argument** can be used with **boolean numbers** (0 and 1) or (FALSE or TRUE).
- After that, the **value in decimal** and **value in percentage id** the same value in Excel and **convert the value to percentage** , if required.
- Finally, you can **feed the arguments** to the **function** directly or using the **cell reference,** as explained in the example.

## Wrap-Up

Hope you understood how to **use the F.DIST Function In Excel Office 365**. Please feel free to state your query or feedback for the above article. Thank you so much for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- **[How to get a comparison product chart in Excel 365?](https://geekexcel.com/how-to-get-a-comparison-product-chart-in-excel-365/)**
- **[Create a Year Over Year Comparison Bar Chart in Excel?](https://geekexcel.com/how-to-create-a-year-over-year-comparison-bar-chart-in-excel/)**
- **[How to Unhide Column in Microsoft Excel 2007?](https://geekexcel.com/how-to-unhide-column-in-microsoft-excel-2007/)**
- **[Excel Formulas to Lookup the Cost for the Product or Service!!](https://geekexcel.com/excel-formulas-lookup-the-cost-for-the-product-or-service/)**
- **[Excel Formulas to Calculate the Cumulative Loan Interest ~ Easily!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-interest-easily/)**