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]