next up previous contents index
Next: STANDARDIZE Up: A. Function Reference Previous: SSE   Contents   Index


SSQ

Syntax: SSQ(argumentlist)

argumentlist = any combination or numbers, cells or ranges

SSQ returns the sum of squares of its arguments. Blank cells and cells containing strings are not counted. The function is given by:

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

Examples:

SSQ(2, 2, 3, 6) = 53

SSQ(G1..G4) = 132, where G1 = -8, G2 = -6, G3 = -4, and G4 = -4

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

Excel function: N/A


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