Excel 2000 in a Nutshell

Name

FREQUENCY

Synopsis

Use FREQUENCY to count the number of times values in an array fall within the specified ranges. For example, this function works well for looking at a series of grades and determining how many fall within each specified range. This function returns an array of values that indicates the number within each range and how many do not fall within any ranges. The array returned always contains one more value than the array specified by the Bins_Array argument.

Getting Results from an Array Function

Some functions return multiple results (an array). If you only apply the function to one cell you will only see the first result of the array. If the array returns multiple results you must first select the number of cells equivalent to the number of values returned in the array, specify the array function, and then press Ctrl+Shift+Enter to apply the function results to all cells in the specified range.

To Calculate

=FREQUENCY(Data_Array, Bins_Array)

Both arguments are required for this function.

Data_Array

Specifies an array of values that you want to use to determine the frequencies. If this array contains no values the function returns an array of zeros.

Bins_Array

Specifies an array of ranges that you want to group the values specified by the Data_Array argument into. For example, if you specify values of 60, 80, and 100 the array function counts the values between 0 and 60, 61 and 80, 81 and 100, and the number outside the range.

Example

Figure 15-16 illustrates how FREQUENCY ...