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.