MVSFORUMS.com

schintala · Posted: Wed May 18, 2005 12:36 pm Post subject: Standard Deviation

Hi Folks,

I need to calculate a Standard Deviation in a DB2 table. Is there any direct mathematical function available. The environment is DB2 V7.1 z/os.

kolusu · Posted: Wed May 18, 2005 12:49 pm Post subject:

Schintala,

Check this link for the column function STDDEV or STDDEV_POP

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.1.6?SHELF=&DT=20010718
164132&CASE=

Check this link for the column function STDDEV_SAMP

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.1.7?SHELF=&DT=20010718164132&CASE=

Check this link for the column function VARIANCE, VAR, or VAR_POP which is used to calculate STDDEV

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.1.9?SHELF=&DT=20010718164132&CASE=

Check this link for the column function VARIANCE_SAMP or VAR_SAMP which is used to calculate STDDEV_SAMP

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.1.10?SHELF=&DT=20010718164132&CASE=

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

schintala · Posted: Wed May 18, 2005 12:52 pm Post subject:

Thanks a lot Kolusu for an immediate response. I appreciate for the help.