**Frequency Function in Excel:** In this article, we will learn how to use **Frequency function** on Microsoft Excel.

## Jump To:

**What is meant by Frequency Function in Excel?****Basic Syntax of Frequency Function in Excel****Example of Frequency Function in Excel****Verdict**

## What is meant by Frequency Function in Excel?

Frequency Function in Excel means a value returns that how **often returns within a set of data** and it returns the **vertical array of numbers**.

## Basic Syntax of Frequency Function in Excel:

The basic syntax of the **Frequency function** in Excel is:

**=FREQUENCY(data_1:data_2, intervals)**

Let us consider an example of the Frequency function.

## Example of Frequency Function in Excel:

To understand the concept of Frequency function, we added some essential example of Frequency function in Excel.

Let us consider a scenario, we have the example data within the range **A11:B11. **Column A contains the **Student’s Name** & Column B contains **Student Marks**.

If you want to check the Frequency of the number “6”, use the below formula to find the frequency;

**=FREQUENCY(B2:B10,6)**

- You need to select the cell
**C2**to print the output - Copy the above formula and paste in the cell C2
- Execute the formula

From the above example, you can see the **6 numbers** are there till “6”. The count “6” is the output of the frequency of the number “6”.

**Let us consider another example:**

From the same data, we need to find the frequency of the number “2”. The formula for finding the frequency of the number “2” is,

**=FREQUENCY(B2:B10,2)**

- You need to select the cell
**C3**to print the output - Copy the above formula and paste in the cell C3
- Execute the formula

From the above example, you can see the **3 numbers** are there till “2”. The count “3” is the output of the frequency of the number “2”.

**Let us consider another example:**

From the same data, we need to find the frequency of the number “10”. The formula for finding the frequency of the number “10” is,

**=FREQUENCY(B2:B10,10)**

- You need to select the cell
**C4**to print the output - Copy the above formula and paste in the cell C4
- Execute the formula

From the above example, you can see the **10 numbers** are there till “10”. The count “10” is the output of the frequency of the number “10”.

## Verdict:

This is the wrap of this tutorial. As we said, this article explains the usage of the Frequency function in Microsoft Excel. If you have any queries related to this tutorial and then feel free to comment us below.

## Comments

0 comments