Frequency function in Excel 2010 I was experimenting with the FREQUENCY function

Question

Frequency function in Excel 2010

I was experimenting with the FREQUENCY function in Excel,   I noticed that, when using this function, a data point that exactly equals a bin value will be included with the lower group, not the higher. For example, if the bins you use are 5, 10, 15, 20, and you have a data point that exactly equals 10, that would be included in the 5-10 bin, not the 10-15 bin as I would have expected. Has anyone found a way to reverse this, and have the function consider the bins as '5 up to 10' and so forth? so that 10 will be counted in 10-15?   

Explanation / Answer

It will not be possible through FREQUENCY function. You can use COUNTIF function to accomplish the same.

=COUNTIFS(A1:A100,">=0",A1:A100,"<5")

=COUNTIFS(A1:A100,">=5",A1:A100,"<10")

=COUNTIFS(A1:A100,">=10",A1:A100,"<15")

.

.

.

.

.

=COUNTIFS(A1:A100,">=25") (If 25 is the last value)

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.