Formulas and Functions

Table Of Contents

reg-ss: The regression sum of squares.

reside-ss: The residual sum of squares.

Usage Notes

It does not matter whether the known x values and known y values are in rows or Â

columns. In either case, the returned array is ordered by rows as illustrated in the

table.

The example assumed ve sets of known x values. If there were more or less than Â

ve, the number of columns in the returned array would change accordingly (it is

always equal to the number of sets of known x values plus 1), but the number of

rows would remain constant.

If additional statistics are not specied in the arguments to LINEST, the returned Â

array is equal to the rst row only.

LOGINV

The LOGINV function returns the inverse of the log-normal cumulative distribution

function of x.

LOGINV(probability, mean, stdev)

Â probability: A probability associated with the distribution. probability is a number

value and must be greater than 0 and less than 1.

Â mean: The mean of the natural logarithm, that is, ln

(x)

. mean is a number value and

is the average (arithmetic mean) of ln

(x)

; the natural logarithm of x.

Â stdev: The standard deviation of the population. stdev is a number value and must

be greater than 0.

Usage Notes

LOGINV is appropriate where the logarithm of x is normally distributed. Â

Example

=LOGINV(0.78, 1.7, 2.2) returns 29.9289150377259.