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.
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,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