Frequency Function question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kalhoun - 18 Oct 2006 17:54 GMT

I'm attempting to use the frequency function but seem to be getting the wrong
solutions.
Th formula is thus: in c2:c5 =Frequency(a2:a17,b2:b5)

It looks to me like the formula is fouling.

data    Bin    freq Fnctn
1    3    6
1    5    9
2    7    12
2    10    13
3
3
4
4
5
5
6
6
7
7
8
8

Reply to this Message

vezerid - 18 Oct 2006 18:24 GMT

Hi,

This is because you did not enter it as an array formula. To do it
properly, select cells C2:C5, enter the formula and then commit with
Ctrl+Shift+Enter (CSE). It will give very different (correct) results.
When testing your data w/o CSE I get exactly the same values, which of
course are wrong.

HTH
Kostis Vezerides

> I'm attempting to use the frequency function but seem to be getting the wrong
> solutions.
[quoted text clipped - 19 lines]
> 8
> 8

Reply to this Message

Domenic - 18 Oct 2006 18:31 GMT

Try the following...

1) Select cells C2:C6

2) Enter the formula...

=FREQUENCY(A2:A17,B2:B5)

3) Confirm with CONTROL+SHIFT+ENTER, not just ENTER

Does this return the correct result?

> I'm attempting to use the frequency function but seem to be getting the wrong
> solutions.
[quoted text clipped - 19 lines]
> 8
> 8

Reply to this Message

kalhoun - 18 Oct 2006 18:58 GMT

Very good. Thank you both.

> Try the following...
>
[quoted text clipped - 31 lines]
> > 8
> > 8

Reply to this Message