FREQUENCY Function

The FREQUENCY function compares a range of data against various intervals. It gives the number of items in the range of data which falls under the interval.
Note: The function is enclosed in { } brackets as it is entered in the cells as an array.

Formula:


=FREQUENCY (Range of Data, List of Intervals)

Video Tutorial:


Let us find the frequency of values falling in a particular interval, using the FREQUENCY function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question