The following article introduces you to the FREQUENCY function - one of the functions in the statistical function group is very popular in Excel.
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:
- The number of items is less than 25. In the cell to calculate enter the formula : = FREQUENCY (D6: D10, E6: E8)
- Press Enter -> Number of items less than 25 is:
- 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:
Above are instructions and some specific examples when using the FREQUENCY function in Excel.
Good luck!