The 2 arrays are the data_array and the bins_array.
The data_array is the array of numbers you want to analyze.
The bins_array is an array of intervals into which you want to group the
values from the data_array.
For example:
Data array.....Bins array
7...................10
40.................20
41.................30
63.................40
67.................50
FREQUENCY performs a series of counts based on the intervals of the
bins_array.
Bins array
10...counts number of values that are <=10
20...counts number of values that are >10 but <=20
30...counts number of values that are >20 but <=30
40...counts number of values that are >30 but <=40
50...counts number of values that are >40 but <=50
Now comes the confusing part. FREQUENCY adds 1 more bin than those listed in
the bins_array. This last bin is for any values that are >50. So, when you
enter the formula you need to enter it to a total number of cells that
equals the number of bins +1.
In this example we have 5 bins listed (10,20,30,40,50) so you need to select
a total of 6 cells then enter the formula as an array.
Based on this sample the results would be:
Data.....Bins.....Formula result
7..........10.......1 = 1 value is <=10
40........20.......0 = 0 values are >10 but <=20
41........30.......0 = 0 values are >20 but <=30
63........40.......1 = 1 value is >30 but <=40
67........50.......1 = 1 value is >40 but <=50
........................2 = 2 values are >50