Statistical functions

Application: Spreadsheet Home Edition

Name	Description	Syntax
F.DIST	Returns the left-tailed F distribution for two data sets	F.DIST(x, deg_freedom1, deg_freedom2, cumulative)
F.DIST.RT	Returns the right-tailed F distribution for two data sets.	F.DIST.RT(x, deg_freedom1, deg_freedom2)
VAR	Returns the variance for a sample of numbers	VAR(value1, [value2, ...])
VARA	Returns the variance for a mixed sample	VARA(value1, [value2, ...])
VARPA	Returns the variance for the entire population	VARPA(value1, [value2, ...])
CORREL	Returns the Pearson correlation coefficient between two data sets	CORREL(data_X, data_Y)
LINEST	Returns the parameters of a straight line that passes closest to all available data points using the least squares method	LINEST(known_data_y, [known_data_x], [b], [stats])
MAX	Returns the largest value in a set of numbers	MAX(value1, [value2, ...])
MEDIAN	Returns the middle of a set of numbers	MEDIAN(value1, [value2, ...])
MIN	Returns the smallest value in a set of numbers	MIN(value1, [value2, ...])
MODE	Returns the most frequent value in a group of numbers	MODE(value1, [value2, ...])
LARGE	Returns the Nth largest value in a set of numbers	LARGE(set, N)
SMALL	Returns the Nth smallest value in a set of numbers	SMALL(set, N)
NORM.DIST	Returns the cumulative distribution function value or probability density value for a given x, mean, and standard deviation	NORM.DIST(x, mean, standard_deviation, cumulative)
RANK.EQ	Returns the rank of a number relative to other numbers in a range or array	RANK.EQ(number, range, [order])
AVERAGE	Returns the arithmetic mean of the numbers	AVERAGE(value1, [value2, ...])
AVERAGEIF	Returns the arithmetic mean of the values that meet the given criterion	AVERAGEIF(range, criterion, [average_range])
STDEV.S	Returns the standard deviation for a sample of values	STDEV.S(value1, [value2, ...])
COUNT	Returns the number of values in a dataset	COUNT(value1, [value2, ...])
COUNTIF	Returns the number of values that meet the specified criterion	COUNTIF(range, criterion)
COUNTIFS	Returns the number of values that meet all specified criteria	COUNTIFS(criterion_range1, criterion1, [criterion_range2, criterion2, ...])
COUNTA	Returns the number of non-empty cells in a dataset	COUNTA(value1, [value2, ...])
COUNTBLANK	Returns the number of empty cells in a given range	COUNTBLANK(range)
FISHER	Returns the Fisher transformation of a specified value	FISHER(value)

Was this helpful?

Yes