In another selection from his series of tutorials on AccountingWEB.com, David Ringstrom illuminates the uses of Excel’s FREQUENCY function.
Excel's FREQUENCY function comes in handy for situations where you want to find out how many values fall within specific ranges. A property portfolio manager, for example, might want to check how many buildings fall within different criteria for floor areas such as 250,000, 500,000, and 1m square feet. Or an examiner might want to show how many students scored particular grades on their exams.
This article explains how to deal with each of these situations.