[AccessD] complex query!!

Hello Steve and Stuart,

sorry that i didn't responce any sooner, but we had troubles with our network.
I am glad that you now understand what i want. Steve its not your age, but my poor explanation. A few mails back i talked about the stdev on the result, that was wrong, i better could have given you a direct example.

I had a hard time to understand why the genetic researcher needs the stdev. I can't give you an answer about this now, but when i have a meating with him, i will ask and let you know then. 


But now. You gave me an example of the calculation {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.}.  Steve your calculation is the stdevp. This calculation is for a whole population. But, i understand, that it doesn't matter. The calculation can't be done in access because it needs a field name. It it possible to write the two values each time to a temp field, do the calculations and write them then to the result table. 


- Pedro Janssen -


From: Steve Erbach <erbachs at gmail.com>
To: Access Developers discussion and problem solving
Date: Tue, 18 Jan 2005 08:20:55 -0600
Subject: Re: [AccessD] complex query!!

Stuart,

O!, Ancient One! We are honored and humbled that you have descended
from your extended care facility to help us in our dire need!

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

...and one could graph the "alikeness", too, I suppose.

I was going to modify the SQL statement I came up with for Pedro a few
messages ago, but I discovered that Access has very poor math
function. It has the exp function (e^x) but no function for raising a
quantity to an arbitrary power. It has the sqr (square root) function
but no function for squaring a number! And the StDev function doesn't
seem to allow me to feed it a range of data points. What it wants is a
field name and that's that. I could fiddle around with logs and such
to get the result that Pedro wants, but sheesh! It's like going back
to using a slide rule! I've decided that I've had enough of that kind
of pie. I don't feel particularly clever this morning.

Steve Erbach
Neenah, WI

On Tue, 18 Jan 2005 11:44:50 +1000, Stuart McLachlan
<stuart at lexacorp.com.pg> wrote:
> 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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com