Calc Guide

Syntax Description
SLOPE(data_Y; data_X) Returns the slope of the linear regression line.
Data_Y is the array or matrix of Y data. Data_X is the
array or matrix of X data.
SMALL(data; rank_c)
Returns the Rank_c-th smallest value in a data set.
Data is the cell range of data. Rank_c is the rank of
the value (2nd smallest, 3rd smallest, etc.) written as
an integer.
STANDARDIZE(number;
mean; STDEV)
Converts a random variable to a normalized value.
Number is the value to be standardized. Mean is the
arithmetic mean of the distribution. STDEV is the
standard deviation of the distribution.
STDEV(number_1; number_2;
... number_30)
Estimates the standard deviation based on a sample.
Number_1; number_2; ... number_30 are
numerical values or ranges representing a sample
based on an entire population.
STDEVA(value_1; value_2; ...
value_30)
Calculates the standard deviation of an estimation
based on a sample. Value_1; value_2; ... value_30
are values or ranges representing a sample derived
from an entire population. Text has the value 0.
STDEVP(number_1;
number_2; ... number_30)
Calculates the standard deviation based on the entire
population. Number_1; number_2; ... number_30
are numerical values or ranges representing a
sample based on an entire population.
STDEVPA(value_1; value_2; ...
value_30)
Calculates the standard deviation based on the entire
population. Value_1; value_2; ... value_30 are
values or ranges representing a sample derived from
an entire population. Text has the value 0.
STEYX(data_Y; data_X) Returns the standard error of the predicted y value
for each x in the regression. Data_Y is the array or
matrix of Y data. Data_X is the array or matrix of X
data.
TDIST(number;
degrees_freedom; mode)
Returns the t-distribution for the given Number.
Degrees_freedom is the number of degrees of
freedom for the t-distribution. Mode = 1 returns the
one-tailed test, Mode = 2 returns the two-tailed test.
TINV(number;
degrees_freedom)
Returns the inverse of the t-distribution, for the given
Number associated with the two-tailed t-distribution.
Degrees_freedom is the number of degrees of
freedom for the t-distribution.
TRIMMEAN(data; alpha) Returns the mean of a data set without the Alpha
proportion of data at the margins. Data is the array
of data in the sample. Alpha is the proportion of the
marginal data that will not be taken into
consideration.
Appendix B Description of Functions 399