Petter Wingren-Rasmussen wrote:
Hi!
My first post here and I'm fairly new to Open office. Couldnt find an answer
to this simple question in the FAQ, built in help or mailing list archives
so I'm posting here.
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. 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..
I haven't used Frequency() yet myself but my looking at help tells me
that the function is an Array Function involving three columns, say A, B
and C though I don't think they have to be adjacent since they are not
the same height . Column A might contain 1000 rows of raw data. Column
B contains upper bounds on the sorting intervals. In your example it
appears these would be 1999, 2599, 6000, and a user-friendly label
">6000". Column C would contain the 4 resulting frequencies,
corresponding to: Data<=1999, 1999<Data<=2599, 2599<Data<=6000, and
6000<Data. It looks like you either use the function wizard, or perhaps
proceed as follows:
1. Get the data arranged in columnar form.
2. Setup the column of interval upper bound
3. Select, .e.g., click on the top cell, press Shift and arrow down to
select the proper number of cells (4 in the example.), type
"=Frequency(", select the data, type a semicolon, select the interval
limit cells (including the user-friendly label), type the closing
parenthesis, THEN press Shift+Ctrl+Enter. The function wizard may be
easier, but I've never tried it.
I hope this makes sense. I seemed to work for the simple case I ran.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]