EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

FREQUENCY Excel Function

By Madhuri ThakurMadhuri Thakur

Home » Excel » Blog » Statistical Functions in Excel » FREQUENCY Excel Function

FREQUENCY Function in Excel

FREQUENCY Function in Excel(Table of Contents)

  • FREQUENCY in Excel
  • FREQUENCY Formula in Excel
  • How to Use FREQUENCY Function in Excel?

FREQUENCY in Excel

The frequency function in excel is used to calculate how many times a number is getting repeated, or in other words, we can say it calculates the occurrence of any number from the selected range of the bin table. If we see the syntax of the Frequency function, we will have data array and bin array, whereas data array is the complete range of data available and bin array is number whose frequency we need to calculate.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

What is the FREQUENCY function in excel?

The FREQUENCY function returns how often values occur within a set of data. It returns a vertical array of numbers.

If you have age data for a group of children, and you want to count how many children fall under different age ranges. Or you have the data of a school student’s and want to see how many students have achieved grade ‘A’, ‘B’, ‘C’ and etc. For the above problems, we could use the FREQUENCY function in Excel.

FREQUENCY Formula in Excel

Below is the FREQUENCY Formula in Excel :

FREQUENCY Formula in Excel

The FREQUENCY Function has two arguments are as below:

  • Data_array – An array or set of values for which you want to count frequencies.
  • Bins_array – An array of intervals (“bins”) for grouping values.

FREQUENCY counts how many times values occur in a dataset. This function has a special characteristic, and its usage is different from another formula. While applying the FREQUENCY Function within a cell, type the formula and then press CTRL+ SHIFT+ ENTER. This creates {} brackets around the formula, and then it interpreted as an array formula by excel. If you simply press ENTER key, then this may return an incorrect result.

As FREQUENCY Function comes under the Statistical functions category, it found under the FORMULAS tab. Please follow the below steps:

  • Click on the FORMULAS tab.

FREQUENCY Function step1

  • Select the More Functions option.

FREQUENCY Function step2

  • Click On the Statistical category.

FREQUENCY Function step3

  • Please select the FREQUENCY Function from the drop-down listed item as per the below screenshot.

FREQUENCY Function step4

  • After clicking on the FREQUENCY function, it will open a pop-up box for Function Arguments.

FREQUENCY Function step5

  • Enter the Data_array, for which you want to count the frequencies.

FREQUENCY Function step6

  • Enter the Bin_array, for which you want to group the values in data_array.

FREQUENCY Function step7

How to Use FREQUENCY Function in Excel?

FREQUENCY Function in Excel is very simple and easy to use. Let us understand the working of the FREQUENCY Function in Excel by some FREQUENCY Formula example.

You can download this FREQUENCY Function Excel Template here – FREQUENCY Function Excel Template

Example #1

We have below some test scores:

FREQUENCY Example 1-1

According to the below intervals, we will apply the FREQUENCY formula.

Popular Course in this category
Sale
Excel Advanced Training (16 Courses, 23+ Projects)16 Online Courses | 23 Hands-on Projects | 140+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (11,400 ratings)
Course Price

View Course

Related Courses
Excel for Marketing Training (8 Courses, 13+ Projects)

FREQUENCY Example 1-2

The interval field is the second argument of the FREQUENCY Function Bins_array, which specifies the maximum values for the score ranges. This means the score is to be split into the ranges 0—60, 61-70, 71-80, 81-90 and 90+.

First, select the cells where we want to apply the FREQUENCY formula.

FREQUENCY Example 1-3

The excel formula {=FREQUENCY(B4:B12,D4:D8)} into cells E4:E8 using CTRL+SHIFT+ENTER to complete the formula. This would give a vertical array with 5 values as below screenshot:

FREQUENCY Example 1-4

The final result is shown below:

FREQUENCY Example 1-5

Explanation:

  • The first value will display in cell E4. The result would be 1 because there is only 1 test score <=60.
  • The second value is 3 because there are 3 test scores between 61 and 70.
  • The third value is 1 because there is only 1 test score between 71 and 80.
  • The Fourth value is 4 because there is 4 test score between 81 and 90.
  • Score 90+ there is no value.

Example #2

We can apply the FREQUENCY Function to decimal values also. Let’s take an example of the heights of 11 children (in centimeters).

FREQUENCY Example 2-1

Now we need to calculate the frequency according to the specified Bins field. The FREQUENCY Function into cells C18:C22 is used to display the number of children whose height falls under the below ranges:

0.00-1.25 meter

1.26-2.75 meter

2.76-4.25 meter

4.26-5.75 meter

Over 5.76 meter

FREQUENCY Example 2-2

As shown in the above screenshot, the Formula used for the FREQUENCY distribution is:

{=FREQUENCY(A18:A28,B18:B21)}

The final result is :

FREQUENCY Example 2-3

Things to Remember

  • First, you need to highlight or select the range of cells for the result for applying an array formula.
  • Type the FREQUENCY Function into the first cell of the highlight range and press CTRL+SHIFT+ENTER.
  • FREQUENCY Function in Excel returns an array of values; it must be entered as an array formula.
  • If the formula displays an error like #N/A, it occurs if the array formula is entered into a range of cells that is too large.

Recommended Articles

This has been a guide to FREQUENCY Function in Excel. Here we discuss the FREQUENCY Formula in excel and how to use the FREQUENCY Function in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. LN Excel Function
  2. RIGHT Function in Excel
  3. EVEN Function in Excel
  4. SUBSTITUTE Function in Excel

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Excel Functions
  • Statistical Functions in Excel
    • COUNTIF Formula in Excel
    • COUNTIF Multiple Conditions
    • COUNTIFS with Multiple Criteria
    • Statistics in Excel
    • Confidence Interval in Excel
    • Interpolate in Excel
    • Linear Programming in Excel
    • COUNTIFS in Excel
    • Excel Variance
    • Normal Distribution Formula in Excel
    • Count Cells with Text in Excel
    • Excel Formula For Rank
    • Linear Regression in Excel
    • COUNTA Function in Excel
    • MAX Formula in Excel
    • Excel NORMSINV
    • Count Names in Excel
    • FORECAST Formula in Excel
    • NPER in Excel
    • Excel Median Formula
    • Lognormal Distribution in Excel
    • Excel Chi Square Test
    • Count Formula in Excel
    • COUNTIF Examples in Excel
    • Excel P-Value
    • COUNTIF Not Blank in Excel
    • Excel Standard Deviation Formula
    • Excel GROWTH Formula
    • Excel Percentile Formula
    • Excel Frequency Formula
    • Excel Average Formula
    • Excel Correlation Matrix
    • Excel Z Score
    • Excel MAX IF Function
    • Z TEST in Excel
    • Excel Trendline
    • Excel F-Test
    • Excel STDEV Function
    • Excel Frequency Distribution
    • DCOUNT Function in Excel
    • Excel MIN Function
    • Excel Forecast Function
    • FREQUENCY Excel Function
    • COUNTIF with Multiple Criteria
    • Standard Deviation in Excel
    • MAX Excel Function
    • Excel QUARTILE Function
    • Excel T.Test Function
    • Excel PERCENTILE Function
    • MODE Excel Function
    • SLOPE Excel Function
    • Excel Median Function
    • Excel TREND Function
    • Excel Count Function
    • Excel LARGE Function
    • SMALL Excel Function
    • COUNTIF Excel Function
    • Excel AVERAGE Function
    • Excel CORREL Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (34+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (23+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (21+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training Certification
  • Online Excel for Marketing Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download FREQUENCY Function Excel Template

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड FREQUENCY Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

Independence Day Offer - EXCEL ADVANCED Training Certification Learn More