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

PROB function - The function returns the probability that values in a range are between two limits in Excel
MODE.MULT function - The function returns a vertical array of the most common values 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!

Micah Soto

Update 19 May 2020

You should read it

May be interested

MAX function - The function returns the largest value in a set of values in Excel
max function: the function returns the largest value in the set of values. syntax: max (number1, [number2], ...)
STDEV.P function - The function returns the standard deviation based on the whole in Excel
stdev.p: the function returns the standard deviation based on the whole population, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.p (number1, [number2] ,.
RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
rank.avg function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the average rank. support functions from execl 2010 version and above
TBILLEQ function - Calculates the returns corresponding to bonds in treasury in Excel
the following article details the meaning and usage of tbilleq function - calculate the profit corresponding to bonds in the treasury.
How to use the Match function in Excel
the match function on excel looks for a value defined in an array, cell range on the data table and returns the position of the value in the array, that range.
PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
percentrank.inc function: the function returns the rank of a value in a dataset as a percentage including values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.inc (array, x, [significance])
PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
percentrank.exc function: the function returns the rank of a value in a dataset as a percentage excluding values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.exc (array, x, [significance])
STDEV.S function - The function returns the standard deviation based on a sample in Excel
stdev.s function: the function returns the standard deviation based on a sample, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.s (number1, [number2], ...)
GEOMEAN function - The function returns the average of a positive array or range of data in Excel
geomean function: the function returns the average of a positive array or range of data. use the function to calculate the average growth when knowing the gross profit with variable interest rates. syntax: geomean (number1, [number2], ...)
SUMPRODUCT function in Excel: Calculates the sum of corresponding values
the sumproduct function is an extremely useful function when you have to deal with a lot of data numbers in microsoft excel. here are the things you need to know about the sumproduct function in excel.