[AccessD] complex query!!

Stuart McLachlan stuart at lexacorp.com.pg
Mon Jan 17 19:44:50 CST 2005


On 17 Jan 2005 at 19:35, Steve Erbach wrote:

> Pedro,
> 
> Just so I'm clear (I'm 52 years old; have a little pity for the aged),

You young pups don't know nuttin.  When you get to my age you have a better 
chance of understanding.  :-)

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

I can see a possible use for it, it  shows how alike the items are  in each 
pair.






-- 
Stuart





More information about the AccessD mailing list