Home Application Office information

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

FREQUENCY function: Function that calculates and returns the frequency of occurrences of values ​​within a certain range and returns a vertical number array. Syntax: FREQUENCY (data_array, bins_array)

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

Picture 1 of FREQUENCY function - Function that calculates and returns the frequency of occurrences of values ​​in a range 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:

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

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

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

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

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

- 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:

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

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

Good luck!

You've just finished reading the article "FREQUENCY function - Function that calculates and returns the frequency of occurrences of values ​​in a range in Excel" edited by the TipsMake team. You can save frequency-function-function-that-calculates-and-returns-the-frequency-of-occurrences-of-values-​​in-a-range-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV GAMMA function - The function returns the gamma function value in Excel
NEXT » FORECAST function - The function returns a value along a linear trend in Excel
Read more