Statistical functions

In the spreadsheet window statistical functions can be entered that perform a calculation on one or two variables or ranges of cells containing numeric values.

For all statistical functions that accept a range as argument, a list of ranges is also accepted as an argument.

E.g. SUM(A1:A3,A10,B5:B6) will calculate the sum of cells A1, A2, A3, A10, B5 and B6.

If one of the cells in the function's range does not have a numeric value, but is empty or has a string value, then this cell will not be taken into account for calculating the result of the function.

AVEDEV(range) Average deviation function

AVERAGE(range) Average function

COEFVAR(range) Coefficient of variation function

COUNT(range) Count function

COUNTNEG(range) Count negative numbers function

COUNTPOS(range) Count positive numbers function

CORREL(range1,range2) Correlation function

COVAR(range1,range2) Covariance function

GEOMEAN(range) Geometric mean function

MAX(range) Maximum function

MEDIAN(range) Median function

MIN(range) Minimum function

PERCENTILE(p,range) Percentile function

SEM(range) Standard error of the mean function

SLOPE(range1,range2) Returns the slope of the regression line

STDEV(range) Standard deviation

SUM(range) Sum function

SUMNEG(range) Sum of negative numbers function

SUMPOS(range) Sum of positive numbers function

TrimMean(k,range) Trimmed mean function

TrimMeanSEM(k,range) Standard error of trimmed mean

TrimMeanLOW(k,ci,range) Lower value of a confidence interval of a trimmed mean

TrimMeanHIGH(k,ci,range) Higher value of a confidence interval of a trimmed mean

VAR(range) Variance function

See also

Privacy & cookies Contact Site map