Calc Guide

Syntax Description
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.
TTEST(data_1; data_2;
mode; type)
Returns the probability associated with a
Student’s t-Test. Data_1 is the dependent array
or range of data for the first record. Data_2 is
Appendix B Description of Functions 457