Forum Discussion
Frequency function in Excel
Hello all! I'm trying to understand how FREQUENCY function works in Excel. I have the sample below. So does FREQUENCY work with ranges? Does it work with specific numbers? Can someone explain ...
Thank you so much for your reply.
Can I ask, what happens if the data are not sorted?
For example:
Thank you so much
The numbers are the boundaries between bins and Excel sizes the bins to the boundaries irrespective of order. If you use the original dataset the values returned are counts of each number.