Next: 7.11.3 Conditional Statistical Functions
Up: 7.11 Quick-Reference Guide to
Previous: 7.11.1 Mathematical Functions
- @AVG(...) -
- The average (arithmetic mean) of its
arguments.
- @CORR(R1, R2) -
- Pearson's product-moment correlation
coefficient for the paired data in ranges R1 and
R2.
- @COUNT(...) -
- A count of its non-blank arguments.
- @F(M, N, F) -
- The integral of Snedecor's
F-distribution with M and N degrees of
freedom from minus infinity to F.
- @ERF(L[, U]) -
- Error function integrated between 0 and
L; if U specified, between L and U.
- @ERFC(L) -
- Complementary error function integrated between
L and infinity.
- @FORECAST(...) -
- Predicted Y values for given
X.
- @FTEST(R1, R2) -
- The significance level (
) of the
two-sided F-test on the variances of the data
specified by ranges R1 and R2.
- @GMEAN(...) -
- The geometric mean of its arguments.
- @HMEAN(...) -
- The harmonic mean of its arguments.
- @LARGE(R, N) -
- The Nth largest value in range
R.
- @MAX(...) -
- The maximum of its arguments.
- @MEDIAN(...) -
- The median (middle value) of the range
R1.
- @MIN(...) -
- The minimum of its arguments.
- @MODE(...) -
- The mode, or most frequently occurring value.
- @MSQ(...) -
- The mean of the squares of its arguments.
- @PERCENTILE(R, N) -
- The value from the range R which
is at the Nth percentile in R.
- @PERCENTRANK(R, N) -
- The percentile rank of the number
N among the values in range R.
- @PERMUT(S, T) -
- The number of T objects that can be
chosen from the set S, where order is significant.
- @PTTEST(R1, R2) -
- The significance level (
) of
the two-sided T-test for the paired samples
contained in ranges R1 and R2.
- @QUARTILE(R, Q) -
- The quartile Q of the data in
range R.
- @RANK(E, R[, O]) -
- The rank of a numeric argument E
in the range R.
- @RMS(...) -
- The root of the mean of squares of its
arguments.
- @SMALL(R, N) -
- The Nth smallest number in range
R.
- @SSE(...) -
- The sum squared error of its arguments. It is
equivalent to @VAR(...)
@COUNT(...).
- @SSQ(...) -
- The sum of squares of its arguments.
- @STD(...) -
- The population standard deviation (N
weighting) of its arguments.
- @STDS(...) -
- The sample standard deviation (N-1 weighting)
of its arguments.
- @SUM(...) -
- The sum of its arguments.
- @T(N, T) -
- The integral of Student's T-distribution
with N degrees of freedom from minus infinity to T.
- @TTEST(R, X) -
- The significance level (
) of the
two-sided single population T-test for the
population samples contained in range R.
- @TTEST2EV(R1, R2) -
- The significance level (
) of
the two-sided dual population T-test for ranges
R1 and R2, where the population variances
are equal.
- @TTEST2UV(R1, R2) -
- The significance level (
) of
the two-sided dual population T-test for ranges
R1 and R2, where the population variances
are not equal.
- @VAR(...) -
- The sample variance (N weighting) of its
arguments.
- @VARS(...) -
- The sample variance (N-1 weighting) of its
arguments.
- @VSUM(...) -
- The ``visual sum'' of its arguments, using
precision and rounding of formatted cell values.
Next: 7.11.3 Conditional Statistical Functions
Up: 7.11 Quick-Reference Guide to
Previous: 7.11.1 Mathematical Functions
NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999