Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
SINH(number) [Category: Math]
Returns the hyperbolic sine of a number.
SKEW(number1,number2,...) [Category: Statistical]]
Returns the skewness of a distribution. Skewness characterizes the degree
of asymmetry of a distribution around its mean. Positive skewness indicates
a distribution with an asymmetric tail extending toward more positive values.
Negative skewness indicates a distribution with an asymmetric tail extending
toward more negative values.
SLN(cost,salvage,life) [Category: Financial]
Returns the straight-line depreciation of an asset for one period.
SLOPE(known_y’s,known_x’s) [Category: Statistical]]
Returns the slope of the linear regression line through data points in known_
y’s and known_x’s. The slope is the vertical distance divided by the horizontal
distance between any two points on the line, which is the rate of change along the
regression line. Guru Tip: See image under FORECAST. Use with INTERCEPT
to describe the linear regression line. The slope value is also the ﬁ rst value
returned from the LINEST function.
SMALL(array,k) [Category: Statistical]]
Returns the k-th smallest value in a data set. Use this function to return values
with a particular relative standing in a data set. Guru Tip: While you frequently
use MIN to ﬁ nd the smallest value, =SMALL(A2:A1000,2) will return the 2nd
smallest value. Great for eliminating outliers. See pages 46 & 49.