Kernel 8.0 APIs Banner [skip navigation]
Office of Information & Technology (OIT) Banner

$$SD^XLFMTH(): Standard Deviation

Reference Type: Supported, Category: Math Functions, Integration Agreement: 10105

Description

This extrinsic function returns the standard deviation. Standard deviation is defined as:

"A measure of variability equal to the square root of the arithmetic average of the squares of the deviations from the mean in a frequency distribution."1

(1Definition as taken from: Webster's New World College Dictionary, Fourth Edition; Michael Agnes, Editor in Chief; David B. Guralink, Editor in Chief Emeritus; Copyright 2001, 2000, 1999 by IDG Books Worldwide, Inc.; ISBN 0-02-863118-8.)

Format

  $$SD^XLFMTH(%s1,%s2,%n)

Input Parameters

%s1:

(required) Sum.

%s2:

(required) Sum of squares.

%n:

(required) Count.

Output

returns:

Returns the standard deviation.

Example

>S X=$$SD^XLFMTH(5,25,2)

>W X
3.53553390593


VA (Internet) / VA(Intranet) / OI / PD / Site Map / Terms of Use / VA Privacy Policy / Accessibility

Reviewed/Updated: September 15, 2011

If you have questions, need more information, or are having accessibility problems with this website, please contact us by E-Mail: Webmasters, Phone: 510-768-6800, or FAX: 510-768-6850.