At 11:55 17/07/2009 +0200, Petter Wingren-Rasmussen wrote:
What I want to do is to make a Frequency table where I can control the intervals exactly.
The only thing I've figured out how to do is something like this:

Values:    Frequency:
1500        345
3000        762
6000        342
9000        211

Where the frequencies as far as I understand it is calculated through what value is closest.

Not so: according to the help text, the values in the first column are interpreted as the upper limits of the relevant classes.

I would like to control those calculated intervals exactly however, as in:

Values:
0-1999
2000-2599
2600-6000
>6000

What syntax should I use for this to work? So far I've tried < and > signs and a:b and a;b without getting it to work..

It's easier than you think. Just put 1999, 2599, and 6000 in the first three cells (assuming all your values are non-negative). It doesn't matter what you put in the fourth cell; indeed, it doesn't matter whether you even include the fourth cell in the range for the second parameter of the FREQUENCY() function. But you do need to include a fourth cell in the results range, to account for any values which happen to exceed 6000.

At 16:52 17/07/2009 +0200, Petter Wingren-Rasmussen wrote:
What I was planning to do was to use the Frequency function that got a syntax that is something like =Frequency(A2:A10,B2:B5) for column B

I'm not sure you have this quite right: there are three columns involved here. The expression you suggest would need to be entered as an array into C2:C5.

Then use the cells of column A to define the intervals so that A2 would contain <1599 and A3 would be 1600-2499 for instance.

No: column A contains the (nine) actual values for which you want the frequency distribution. Column B contains the (three, plus one ignored) upper limits of the classes. Column C will receive the (four) calculated frequency values.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to