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]

Reply via email to