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

GAMMA function - The function returns the gamma function value in Excel
gamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
GAMMA.DIST function - The function returns the gamma distribution in Excel
gamma.dist: the function returns the gamma distribution, using this function to study skewed distribution variables. support functions from excel 2010 onwards. syntax: gamma.dist (x, alpha, beta, cumulative)
SECOND function - The function returns the second part of a time value in Excel
second function: the function returns the second part of the time value. the second value is an integer, and has a value between 0 and 59 seconds. syntax: second (serial_number)
TIME function - Function returns decimal numbers for a specific time value in Excel
time function: the function returns the decimal number for a time value. the decimal number that the function returns is from 0 to 0.99988426, which corresponds to the time from 0:00:00 (12:00:00 am) to 23:59:59 (11:59:59 pm). syntax: time (hour, minute, second)
TIMEVALUE function - The function returns the decimal number of time expressed as a text string in Excel
timevalue function: the function returns the decimal number of time indicated by a text string. the decimal number that the function returns is from 0 to 0.99988426, which corresponds to the time from 0:00:00 (12:00:00 am) to 23:59:59 (11:59:59 pm). syntax: timevalue (time_text)
AVEDEV function
avedev function: the function returns the average absolute deviation of the data points from their midpoint. the avedev function allows you to measure the variability of a dataset. syntax: avedev (number1, [number2], ...)