Microsoft Office Tutorials and References
In Depth Information
The LOGEST function is used in regression analysis. The equation for the cur ve is y=b*m^x .
Because the result is an array, the formula must be array entered by using Ctrl+Shift+Enter,
instead of just Enter. Figure 11.25 shows an example of LOGEST .
The known values for the known data points; the dependent variable.
KNOWN_Y’S
The known data points. If omitted assumed to be the array {1,2,3…} the
same size as the known_y’s .
KNOWN_X’S
TRUE or FALSE indicating whether to force b to be = 1 (FALSE) or not
(TRUE). When TRUE or omitted, b is calculated normally.
CONST
If stats is TRUE, LOGEST returns the additional regression statistics. If
stats is FALSE or omitted, LOGEST returns only the M coefficient and
the Constant b.
STATS
Figure 11.25
The LOGEST function
returns values that
describe the existing
curve. Use the GROWYH
function to predict
future values on the
curve.
LOGINV returns the inverse of the LOGNORMDIST (lognormal cumulative distribution) function of
x, where ln(x) is normally distributed with parameters mean and standard deviation.
The LOGNORMDIST function generates a probability p=LOGNORMDIST(x,...) . The LOGINV
function takes a probability as on of its arguments and generates x—LOGINV(p,...)=x . So that