FREQUENCY()
Syntax. FREQUENCY(data_array,bins_array)
Definition. This function returns a frequency distribution as single-column matrix. For example, use FREQUENCY() to count the sales in a certain area. Because FREQUENCY() returns an array of values, it must be entered as an array formula.
Arguments
data_array (required). An array of or a reference to a set of values for which you want to count frequencies. If data_array contains no values, FREQUENCY() returns an array of zeros.
bins_array (required). An array of or reference to intervals into which you want to group the values in data_array. If bins_array contains no values, FREQUENCY() returns the number of elements in data_array.
Background. To reduce the quantitative data, the existing data are ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
