Ø @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.