next up previous contents index
Next: 7.11.3 Conditional Statistical Functions Up: 7.11 Quick-Reference Guide to Previous: 7.11.1 Mathematical Functions

7.11.2 Statistical 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 ( tex2html_wrap_inline15161 ) 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 ( tex2html_wrap_inline15161 ) 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(...) tex2html_wrap_inline15165 @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 ( tex2html_wrap_inline15161 ) of the   two-sided single population T-test for the population samples contained in range R.

@TTEST2EV(R1, R2) -
The significance level ( tex2html_wrap_inline15161 ) 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 ( tex2html_wrap_inline15161 ) 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 up previous contents index
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