# 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.

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 …