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 …