Buzz
The purpose of the FREQUENCY function in Excel is to calculate the frequency of occurrence of value ranges in the given data array. Follow the article below to learn about its syntax and usage.
FREQUENCY function
Using the FREQUENCY Function in Excel - Illustrative Example
Syntax: FREQUENCY(Data_array,Bins_array)
Where: Data_array: The provided data array
Bins_array: An array containing value ranges to calculate frequencies.
All parameters in the FREQUENCY function are mandatory.
As the result returned by the FREQUENCY function is an array of numbers, before using the function, we must select the array to display the result. To display the returned result on those cells, after entering the syntax, press CTRL+SHIFT+ENTER.
Illustrative Example: Consider a table of students' scores and count the number of students classified as weak, average, good, and excellent.
Convention: Weak below 5 points
Average: from 5 to 7 points
Good: from 7 to 8 points
Excellent: above 8 points
Using the formula: =FREQUENCY(D5:D9,E5:E9)
Outcome:
Thus, the above article has instructed you on how to use the FREQUENCY function to count the frequency of occurrence of values, allowing you to apply it effectively in your work and studies. Additionally, Excel offers many percentage calculations that you can use to calculate values in your work.
In Excel, there are also many functions such as the Index function, Sum function... that provide you with many applications in your work. Similar to FREQUENCY, when using the Index function, Sum function, you also need to understand the syntax.
