• Dp

"FREQUENCY" Function In Excel

Updated: May 2, 2019

This function compares a range of data against a list of intervals.The result shows how many items in the range of data fall between the intervals.The function is entered in the cells as an array, that is why it is enclosed in { } braces.


Syntax:

=FREQUENCY(RangeOfData,ListOfIntervals)


Example:

Following table records the marks of a student in 3 different months. Frequency function is used to calculate the frequency of Marks scored.



Video Tutorial:

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at dptutorials15@gmail.com

Support my blog, if you liked

  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • Google+ Social Icon
  • Blogger Social Icon