[AccessD] complex query!!

Steve Erbach erbachs at gmail.com
Mon Jan 17 19:35:45 CST 2005


Pedro,

Just so I'm clear (I'm 52 years old; have a little pity for the aged),
do you want what Stuart suggested? That is:

For each pair of values that are used to generate an average, you want
the standard deviation of that pair of data points? For two points the
standard deviation is equal to the difference between one of the
points and the average. So if the points are 8.4 and 9.3, the average
is 8.85. The "standard deviation" would be 9.3 - 8.85 = 0.45. Is that
what you want? I mean, it's easy enough to compute, but I'm having a
hard time seeing how useful it is.

Steve Erbach
Neenah, WI

On Mon, 17 Jan 2005 23:27:04 +0100, Pedro Janssen <pedro at plex.nl> wrote:
> 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 -



More information about the AccessD mailing list