Why result = 4

  • Thread starter Thread starter Andri
  • Start date Start date
A

Andri

Dear All,

Please help for the below formula.

Respectfully,
andry

=FREQUENCY({1,2,1,1,5,6,6,5,5,10,10,1},{1,2,1,1,5,6,6,5,5,10,10,1}) CSE,
result =4?
 
Dear All,

Please help for the below formula.

Respectfully,
andry

=FREQUENCY({1,2,1,1,5,6,6,5,5,10,10,1},{1,2,1,1,5,6,6,5,5,10,10,1}) CSE,
result =4?
Click to expand...

It actually returns {4;1;0;0;3;2;0;0;0;2;0;0;0}. You need to enter the
CSE formula in 12 cells vertically to get all the answers to show.
With only one cell, it shows the first answer.
 
Andri said:
Please help for the below formula. ....
=FREQUENCY({1,2,1,1,5,6,6,5,5,10,10,1},{1,2,1,1,5,6,6,5,5,10,10,1}) CSE,
result =4?
Click to expand...

This formula returns the array

{4;1;0;0;3;2;0;0;0;2;0;0;0}

The 'bin' array second argument is highly redundant. Excel ignores
second and subsequent duplicates in the bin array. The first value in
the bin array is 1, and there are 4 instances of 1 in the data array
first argument. The second value in the bin array is 2, and there's
only 1 instance of 2 in the data array. The third value in the bin
array is 1, but it appears before in the bin array, so FREQUENCY
ignores it and returns 0.

If you mean you select a SINGLE cell, type this formula and press
[Ctrl]+[Shift]+[Enter], Excel would return a value, the first item in
the FREQUENCY function's result array, in that single cell. If you
want to see the entire result array, in this case you'd need to select
a 1-column, 13-row range of cells, type in the formula, then press
[Ctrl]+[Shift]+[Enter]. That will fill the range with the result
array.

Excel DOES NOT automatically expand array formulas into enough cells
to hold the entire array result. Excel ONLY returns array formula
results to the cells into which you enter the array formulas.
 
The number 4 is the result for the frequency of the "1" in your series.

You need to reference the cells as a range, such as a1:a10.
Your formula should look like this:

=frequency(a1:a10,a1:a10) enter it as an array, (ctl-shift-enter), then drag
down the array to copy the formula down at least as many different
frequencies you are looking for plus at least one.

The two portions of the formula reference the same range because you are
looking for the frequency of all the different results.

Squeaky
 
Back
Top