[AccessD] complex query!!

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 -



----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problemsolving"
<accessd at databaseadvisors.com>
Sent: Sunday, January 16, 2005 1:17 AM
Subject: Re: [AccessD] complex query!!


> On 15 Jan 2005 at 20:33, Pedro Janssen wrote:
>
> > Hi Steven,
> >
> > i realy need the standarddeviatian om each result, otherwise the
statistical
> > calculation isn't correct for this king of genetic research.
> >
>
> Standard deviation is a measure of the overall distribution of your data
> set.  Roughly speaking, it is the mean of the squares of the differences
> between individual data values and the mean data value.
>
> There is no such thing as "standard deviation on each result". What is it
> you actually want for each result?
>
> Do you want it's variance from the mean expressed as a multipe of "one
> standard deviation for the dataset" ?
>
>
> --
> Stuart
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>