Statistical Functions

XNPV

Returns the present value for a schedule of cash flows that is not necessarily periodic.

T.DIST

Returns the Student's left-tailed t-distribution.

T.DIST.2T

Returns the two-tailed Student's t-distribution.

T.DIST.RT

Returns the right-tailed Student's t-distribution.

T.INV

Returns the left-tailed inverse of the Student's t-distribution.

T.INV.2T

Returns the two-tailed inverse of the Student's t-distribution.

TAN

Returns the tangent of the given angle.

TANH

Returns the hyperbolic tangent of a number.

VAR.P

Returns the variance of the entire population.

VAR.S

Returns the variance of a sample population.

VARX.P

Returns the variance of the entire population.

VARX.S

Returns the variance of a sample population.

XIRR

Returns the internal rate of return for a schedule of cash flows that is not …

TOPN

Returns the top N rows of the specified table.

ROW

Returns a table with a single row containing values that result from the expressions given …

RANKX

Returns the ranking of a number in a list of numbers for each row in …

RANK.EQ

Returns the ranking of a number in a list of numbers.

POISSON.DIST

Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number …

PERCENTILEX.INC

Returns the percentile number of an expression evaluated for each row in a table.

PERCENTILEX.EXC

Returns the percentile number of an expression evaluated for each row in a table.

PERCENTILE.INC

Returns the k-th percentile of values in a range, where k is in the range …

PERCENTILE.EXC

Returns the k-th percentile of values in a range, where k is in the range …

NORM.S.INV

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of …

NORM.S.DIST

Returns the standard normal distribution (has a mean of zero and a standard deviation of …

STDEV.S

Returns the standard deviation of a sample population.

SAMPLE

Returns a sample of N rows from the specified table.

SELECTCOLUMNS

Adds calculated columns to the given table or table expression.

SIN

Returns the sine of the given angle.

SINH

Returns the hyperbolic sine of a number.

SQRTPI

Returns the square root of (number * pi).

STDEV.P

Returns the standard deviation of the entire population.

STDEVX.P

Returns the standard deviation of the entire population.

STDEVX.S

Returns the standard deviation of a sample population.

SUMMARIZE

Returns a summary table for the requested totals over a set of groups.

MINX

Returns the smallest value that results from evaluating an expression for each row of a …

NORM.INV

The inverse of the normal cumulative distribution for the specified mean and standard deviation.

NORM.DIST

Returns the normal distribution for the specified mean and standard deviation.

MINA

Returns the smallest value in a column.

COUNTX

Counts the number of rows that contain a non-blank value or an expression that evaluates …

CROSSJOIN

Returns a table that contains the Cartesian product of all rows from all tables in …

DATATABLE

Provides a mechanism for declaring an inline set of data values.

DISTINCTCOUNT

Counts the number of distinct values in a column.

DISTINCTCOUNTNOBLANK

Counts the number of distinct values in a column.

EXPON.DIST

Returns the exponential distribution. Use EXPON.DIST to model the time between events, such as how …

GENERATE

Returns a table with the Cartesian product between each row in table1 and the table …

GENERATEALL

Returns a table with the Cartesian product between each row in table1 and the table …

GEOMEANX

Returns the geometric mean of an expression evaluated for each row in a table.

MAX

Returns the largest value in a column, or between two scalar expressions.

MAXA

Returns the largest value in a column.

MAXX

Evaluates an expression for each row of a table and returns the largest value.

MEDIAN

Returns the median of numbers in a column.

MEDIANX

Returns the median number of an expression evaluated for each row in a table.

MIN

Returns the smallest value in a column, or between two scalar expressions.

GEOMEAN

Returns the geometric mean of the numbers in a column.

CHISQ.INV

Returns the inverse of the left-tailed probability of the chi-squared distribution. The chi-squared distribution is …

CHISQ.DIST.RT

Returns the right-tailed probability of the chi-squared distribution. The chi-squared distribution is associated with a …

CHISQ.DIST

Returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the …

BETA.INV

Returns the inverse of the beta cumulative probability density function (BETA.DIST). If probability = BETA.DIST(x,...TRUE), …

BETA.DIST

Returns the beta distribution. The beta distribution is commonly used to study variation in the …

AVERAGEX

Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.

AVERAGEA

Returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric …

AVERAGE

Returns the average (arithmetic mean) of all the numbers in a column.

ADDCOLUMNS

Adds calculated columns to the given table or table expression.

APPROXIMATEDISTINCTCOUNT

Returns the approximate number of rows that contain distinct values in a column. This function …

CHISQ.INV.RT

Returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHISQ.DIST.RT(x,...), …

CONFIDENCE.NORM

The confidence interval is a range of values. Your sample mean, x, is at the …

CONFIDENCE.T

Returns the confidence interval for a population mean, using a Student's t distribution.

COT

Returns the cotangent of an angle specified in radians.

COTH

Returns the hyperbolic cotangent of a hyperbolic angle.

COUNT

The COUNT function counts the number of cells in a column that contain non-blank values.

COUNTA

The COUNTA function counts the number of cells in a column that are not empty.

COUNTAX

The COUNTAX function counts nonblank results when evaluating the result of an expression over a …

COUNTBLANK

Counts the number of blank cells in a column.

COUNTROWS

The COUNTROWS function counts the number of rows in the specified table, or in a …