FREQUENCY

Definition: FREQUENCY is a function that returns a frequency distribution for a set of values.

Syntax: =FREQUENCY(data_array, bins_array)

Situation: This formula is suitable when you need to find a frequency distribution for a set of values.

Example: If you have a set of values 1, 2, 3, 4, and 5, and want to group them into bins with a width of 2, the frequency distribution can be found using the formula =FREQUENCY(A1:A5, {0,2,4,6}), which returns {2,2,1}.