Formulas and Functions

Chapter 10 Statistical Functions 253
DEVSQ
The DEVSQ function returns the sum of the squares of deviations of a collection of
numbers from their average (arithmetic mean).
DEVSQ(num-value, num-value…)
 num-value: A number. num-value is a number value.
 num-value…:Optionally include one or more additional numbers.
Usage Notes
DEVSQ divides the sum of the numbers by the number of numbers to get the Â
average (arithmetic mean). The dierence (absolute value) between the average and
each number is squared and summed and the total is returned.
Example
=DEVSQ(1, 7, 19, 8, 3, 9) returns 196.833333333333.
Related Topics
For related functions and additional information, see:
“STDEV”
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
EXPONDIST
The EXPONDIST function returns the exponential distribution of the specied form.
EXPONDIST(non-neg-x-value, lambda, form-type)
 non-neg-x-value: The value at which you want to evaluate the function. non-neg-x-
value is a number value that must be greater than or equal to 0.
 lambda: The parameter value. lambda is a number value and must be greater than 0.
 form-type: A value that indicates which form of the exponential function to
provide.
cumulative form (TRUE or 1): Return the value of the cumulative distribution
function form.
probability density form (FALSE or 0): Return the value of the probability density
function form.