in ,

ExcelExcel

How to Use Frequency Function in Microsoft Excel?

Usage of Frequency Function in Microsoft Excel!

Use Frequency Function in Excel

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?

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.

Example for Frequency Function
Example for Frequency Function

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
Output of the Frequency Function
The output of the Frequency Function

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
The output of the frequency function
The output of the frequency function

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
The output of the Frequency Function
The output of the Frequency Function

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.

Article Review
  • Article Explanation
  • Function Discussed
  • Formula Explained
  • Images Explanation
4.8

Summary

Find more articles on our HomePage

Leave a Reply

Your email address will not be published. Required fields are marked *

Loading…

0

Comments

0 comments