next up previous contents index
Next: ROUND Up: A. Function Reference Previous: RIGHT   Contents   Index


RMS

Syntax: RMS(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

RMS returns the square root of the mean of squares of its arguments. Blank cells and cells containing strings are not counted. The function is given by:

\begin{displaymath}
\sqrt{\frac{1}{N} \sum_{i=1}^N a_i^2}
\end{displaymath}

Examples:

RMS(2, 2, 3, 6) = 3.6400549

RMS(H8..H11) = 97.3413, where H8..H11 are 96, 97, '', and 99

RMS(D1..D6) = 48.72029, where D1..D6 = 4, 56, 33, 100, 0, and -1

Excel function: N/A


next up previous contents index
Next: ROUND Up: A. Function Reference Previous: RIGHT   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003