[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 -