Page 268 - Excel Data Analysis
P. 268
14 537547 AppB.qxd 3/4/03 11:57 AM Page 254
APPENDIX
EXCEL FUNCTION QUICK REFERENCE
(CONTINUED)
STATISTICAL FUNCTIONS (CONTINUED)
FUNCTION DESCRIPTION
SLOPE(known_y's, known_x's) Finds the slope of a linear regression line.
SMALL(array, k) Finds the value that is the specified number within an array
based upon its size.
STANDARDIZE(x, mean, standard_dev) Finds the value when you know the mean and the standard
deviation.
STDEV(number1[, number2,...]) Estimates the standard deviation of numeric values based upon
a sample.
STDEVA(value1[, value2,...]) Estimates the standard deviation of numeric, text, and logical
values based upon a sample.
STDEVP(number1[, number2,...]) Estimates the standard deviation of numeric values based upon
the entire population.
STDEVPA(value1[, value2,...]) Estimates the standard deviation of numeric, logical, and text
values based upon the entire population.
STEYX(known_y's, known_x's) Finds the standard error for each y-value.
TDIST(x, degrees_freedom, tails) Finds the Student t-distribution probability for the specified
value.
TINV(probability, degrees_freedom, tails) Finds the inverse of Student t-distribution probability for the
specified value.
TREND(known_y's[, known_x's, new_x's, const]) Finds the values that match a linear trend using the method of
least squares.
TRIMMEAN(array, percent) Finds the mean of the interior of a list of numeric values.
TTEST(array1, array2, tails, type) Determines if two samples are from the same population.
VAR(number1[, number2,...]) Estimates the variance of numeric values based upon a sample.
VARA(value1[, value2,...]) Estimates the variance of numeric, text, and logical values based
upon a sample.
VARP(number1[, number2,...]) Estimates the variance of numeric values based upon the entire
population.
VARPA(value1[, value2,...]) Estimates the variance of numeric, logical, and text values based
upon the entire population.
WEIBULL(x, alpha, beta, cumulative) Finds the possibilities of a Weibull distribution.
ZTEST(array, x[, sigma]) Finds the two-tailed P-value of a Z-test.
254
