[AccessD] complex query!!

Hello Steve,

i agree that it is a little fuzzy (and maybe strange to you)
but the evolutionary genetics specialist, specific asked for the Stdev
of each (in this case) AverageVal. So teh StDev for A1:B1, A1:B2, A1:B3. etc
I'll jope this explaines enough

- Pedro -


----- Original Message -----
From: "Steve Erbach" <erbachs at gmail.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, January 17, 2005 6:19 PM
Subject: Re: [AccessD] complex query!!


> Pedro,
>
> I'm still a little fuzzy on the concept, here. Your results table
> looks like this:
>
> AvgUsing AverageVal
> A1:B1      8.5
> A1:B2      9.2
> A1:B3      8.9
> A2:B1      7.8
> A2:B2      7.9
> A2:B3      7.7
> A3:B1      8.2
> A3:B2      8.0
> A3:B3      8.4
>
> The standard deviation for this set of data is 0.510989950108173. The
> mean is 8.2888887723287. Do you want to see the number of standard
> deviations each data point is away from the mean?
>
> Steve Erbach
> Neenah, WI
>
>
> On Sun, 16 Jan 2005 21:30:34 +0100, Pedro Janssen <pedro at plex.nl> wrote:
> > Hello Stuart and Steven,
> >
> > normally i agree with you two, but in this particular case, i need the
> > standard deviation
> > on the average of the two records, group1.record1 vs group2.record2 etc
etc
> > etc for
> > all the results of the Cartesian product.
> > Let me tell you why.
> > In my free time i lead a research project on the genetic diversity of
> > adderpopulations.
> > There are a few questions in this project that i and my co-worker can't
> > solve,
> > because its very specific. We get help from some external specialists.
They
> > ask use
> > what they need for giving us the answers to our population questions.
> > One researcher asked the standard deviation for each of the averages.
> >
> > So that's why i am asking this.
> >
> > I'll hope this will answer your questions.
> >
> > - Pedro Janssen -
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>