Excel Function : FREQUENCY

Download now!

Excel Function : FREQUENCY

Category

Statistical

Description

Returns a frequency distribution as a vertical array

Microsoft Excel Reference Page

https://support.office.com/en-us/article/FREQUENCY-function-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9

Syntax and Description of the FREQUENCY Excel Function

FREQUENCY returns the number of data points in a data set that fall within a group of bins.

About FREQUENCY Excel Function

The FREQUENCY function returns a frequency distribution, which is a summary of values in a data set. The function uses the following syntax: FREQUENCY(data, bins). The data argument is the data set and the bins argument is the number of bins. The function returns an array of values that represent the frequency distribution.