Need help for standardize function

  • Thread starter Thread starter ButBi
  • Start date Start date
B

ButBi

In Ecxel I use standardize() function to calculate some items. How do I
calculate it in Access. Any help is very appreciated.

Thank you!
 
ButBi said:
In Ecxel I use standardize() function to calculate some items. How do I
calculate it in Access. Any help is very appreciated.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The Standardize function's formula is

(x - mean)/standard deviation

where x is the value you want to normalize. You have to provide the
mean and standard deviation.

So you could either make a VBA function or just in-line the calculation
in a query. Mean is "selected count / population count" and SQL has a
built-in function StdVar() for standard deviation.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkHZu4echKqOuFEgEQIyfwCfRnCDsjHvOcptyD+Yo+2Ytkf6ElEAn3k9
M+KYOaD/o1qiiQczPhb2xhTf
=btRk
-----END PGP SIGNATURE-----
 
MGFoster said:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The Standardize function's formula is

(x - mean)/standard deviation

where x is the value you want to normalize. You have to provide the
mean and standard deviation.

So you could either make a VBA function or just in-line the calculation
in a query. Mean is "selected count / population count" and SQL has a
built-in function StdVar() for standard deviation.
Click to expand...

Correction: The name of the standard deviation aggregate function is
StDev().
 
Back
Top