Top post for a quick question:
Do you mean "median" which is the middle number of a group of numbers?
Or do you mean "mean" which is the sum of a group of numbers divided
by the quantity of numbers in the group?
For example: 8,8,9,12,22
The median number for this group of numbers is 9. The mean is 11.8. If
you are looking for the mean for a field in a database, this is
possible in a query.
Dan
On Monday March 26 2007 1:39 pm, Franco wrote:
> "Dan Lewis" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>
> > On Saturday March 24 2007 5:32 am, Ron Ferguson wrote:
> > > Dave Barton wrote:
> > > > -------- Original Message --------
> > > > From: Ron Ferguson <[EMAIL PROTECTED]>
> > > > Date: Sat 24 Mar 2007 05:21:56 EST
> > > >
> > > > 8<-- snip -->8
> > > >
> > > >> I, for one, have yet to find any sign of this "To get
> > > >> information about driver specific functions refer to the
> > > >> documentation of your database system."
> > > >>
> > > >> As yet there does not seem to be anything other than the
> > > >> rather basic Starting documentation.
> > > >>
> > > >> Ron Ferguson
> > > >
> > > > Maybe you can find the information you need in the HSOLDB
> > > > docs: http://hsqldb.org/web/hsqlDocsFrame.html
> > > >
> > > > Hope this helps.
> > > >
> > > > Dave
> > >
> > > Thanks Dave,
> > >
> > > I have studied those pages and whilst they give the parameters
> > > for the use of HSQL they do not give any information about its
> > > implementation in OOo.
> > >
> > > The documentation for the use of Base is very poor indeed. It
> > > may be fine for someone with plenty of experience in using SQL
> > > directly and linking to it via a database manager but for
> > > someone relatively new to using SQL in any of its various
> > > guises it is pretty hopeless. A great shame really as only a
> > > limited number of commands have been incorporated as yet .
> > >
> > > Ron Ferguson
> >
> > I absolutely agree with you on this point. It seems that no
> > one who understands databases in general and SQL in particular is
> > willing to take the time to write how to use Base.
> >
> > Dan
>
> I would like to thank Harold and all for replying. From what I've
> read, it seems that Base requires a level of expertise that I don't
> have and for me to acquire that expertise could be an exercise in
> mental anguish. I'm using Calc to do median calcuatlions on my
> data, but it's a littled tedious and I thought a database would
> solve this. I've used the database in Microsoft Works, and even if
> this program is the humblest of the humble databases, it was
> FANTASTICALLY easy to use and set up and did everything I needed
> EXECPT calcuate the median!
>
> Maybe the next release of Base will be more user friendly (if
> that's the right way to put).
>
> Thanks again and best wishes,
> Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
