Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

in O5). The ﬁ nal column is the intercept. The ﬁ rst row of values is the slope. The

second line is the standard error. I always pay attention to line 3, column 1 as

this is the R-Squared. This ranges from 0 to 1. The closer you are to 1, the better

your regression is at predicting sales. In the present example, I would probably

go back and try to ﬁ nd some other causal variables since an R-squared of 0.66

means that my current variables aren’t doing a good job of predicting sales.

They are better than random, but not perfect.

LN(number) [Category: Math]

Returns the natural logarithm of a number. Natural logarithms are based on the

constant e (2.71828182845904).

LOG(number,base) [Category: Math]

Returns the logarithm of a number to the base you specify.

LOG10(number) [Category: Math]

Returns the base-10 logarithm of a number.

LOGEST(known_y’s,known_x’s,const,stats) [Category: Statistical]]

In regression analysis, calculates an exponential curve that ﬁ ts your data and

returns an array of values that describes the curve. Because this function returns

an array of values, it must be entered as an array formula.

LOGINV(probability,mean,standard_dev) [Category: Statistical]]

Returns the inverse of the lognormal cumulative distribution function of x, where

ln(x) is normally distributed with parameters mean and standard_dev. If p =

LOGNORMDIST(x,...) then LOGINV(p,...) = x.

LOGNORMDIST(x,mean,standard_dev) [Category: Statistical]]

Returns the cumulative lognormal distribution of x, where ln(x) is normally

distributed with parameters mean and standard_dev. Use this function to analyze

data that has been logarithmically transformed.

LOOKUP(lookup_value,lookup_vector,result_vector) [Category: Lookup

& Reference]

Returns a value either from a one-row or one-column range. This vector form

of LOOKUP looks in a one-row or one-column range (known as a vector) for a

value and returns a value from the same position in a second one-row or one-

column range. Included for compatibility with other worksheets. Use VLOOKUP

instead.

LOOKUP(lookup_value,array) [Category: Lookup & Reference]

Returns a value from an array. The array form of LOOKUP looks in the ﬁ rst row

or column of an array for the speciﬁ ed value and returns a value from the same

position in the last row or column of the array. Included for compatibility with

other spreadsheet programs. Use VLOOKUP instead.