Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
in O5). The fi nal column is the intercept. The fi 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 fi 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 fi 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 fi rst row
or column of an array for the specifi 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.
 
Search JabSto ::




Custom Search