$$SD^XLFMTH(): Standard Deviation

Reference Type: Supported, Category: Math Functions, ICR#: 10105

Description

The $$SD^XLFMTH 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."¹

(¹Definition 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

Output

Example

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

>W X
3.53553390593