Using Excel’s Frequency function

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.

Property floor area worksheet using FREQUENCY function

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.