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.

SQL.REQUEST(connection_string,output_ref,driver_prompt,query_

text,col_names_logical)*