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 ...

For example, if you want to show a frequency distribution for every 10 units you would need to define that for Excel. The Frequency function refers to this limit as the "Bin Array." ...