FREQUENCY function - Function that calculates and returns the frequency of occurrences of values ​​in a range in Excel

The following article introduces you to the FREQUENCY function - one of the functions in the statistical function group is very popular in Excel.

FREQUENCY function - Function that calculates and returns the frequency of occurrences of values ​​in a range in Excel Picture 1

Description: The function performs the calculation and returns the frequency of occurrences of values ​​within a certain range and returns a vertical array of numbers.

Syntax: FREQUENCY (data_array, bins_array)

Inside:

- data_array: Array or reference to a set of values ​​to calculate its frequency.

- bins_array: Array or reference to the values ​​to be calculated.

Attention:

- The function ignores values ​​of blank cells and text.

- The number of components in data_array returns more than the number of components in bins_array.

- Array formulas must be entered as an array formula

For example:

Find the number of items with a quantity less than 35 or 40 in the data table below:

FREQUENCY function - Function that calculates and returns the frequency of occurrences of values ​​in a range in Excel Picture 2

- The number of items is less than 25. In the cell to calculate enter the formula : = FREQUENCY (D6: D10, E6: E8)

FREQUENCY function - Function that calculates and returns the frequency of occurrences of values ​​in a range in Excel Picture 3

- Press Enter -> Number of items less than 25 is:

FREQUENCY function - Function that calculates and returns the frequency of occurrences of values ​​in a range in Excel Picture 4

- Similarly copy for cases where the number is less than or equal to 40 -> enter the formula: = FREQUENCY (D6: D10, E7: E9) -> press Enter to get the results:

FREQUENCY function - Function that calculates and returns the frequency of occurrences of values ​​in a range in Excel Picture 5

Above are instructions and some specific examples when using the FREQUENCY function in Excel.

Good luck!