[AccessD] complex query!!

Steve Erbach erbachs at gmail.com
Fri Jan 21 14:31:43 CST 2005


Pedro,

Oh, I think I understand well enough. Say the two data points are 7
and 10. The average is 8.5. The population standard deviation is
calculated by hand like this:

(10 - 8.5)^2 = 2.25
(7 - 8.5)^2 = 2.25
2.25 + 2.25 = 4.5
4.5/2 = 2.25
2.25^0.5 = 1.5

My formula is:

(10 - 7)/2 = 1.5

So rather than go through the rigamarole of calculating a standard
deviation I just took the short cut.

Steve Erbach
Neenah, WI



On Fri, 21 Jan 2005 20:08:54 +0100, Pedro Janssen <pedro at plex.nl> wrote:
> Hello Steve,
> 
> thanks for the time and help with my question.
> Although you do not fully understand the use of the last StDev question, i
> very grateful that you helped me. It saves me a lot of time.
> 
> Pedro Janssen



More information about the AccessD mailing list