Statistical Functions


Statistical aggregation functions.

Function Description
BETA.DIST Returns the beta distribution. The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
BETA.INV Returns the inverse of the beta cumulative probability density function (BETA.DIST). If probability = BETA.DIST(x,...TRUE), then BETA.INV(probability,...) = x. The beta distribution can be used in project planning to model probable completion times given an expected completion time and variability.
CHISQ.DIST Returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
CHISQ.DIST.RT Returns the right-tailed probability of the chi-squared distribution. The chi-squared distribution is associated with a chi-squared test. Use the chi-squared test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants will exhibit a certain set of colors. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid.
CHISQ.INV Returns the inverse of the left-tailed probability of the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
CHISQ.INV.RT Returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHISQ.DIST.RT(x,...), then CHISQ.INV.RT(probability,...) = x. Use this function to compare observed results with expected ones in order to decide whether your original hypothesis is valid.
COMBIN Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.
COMBINA Returns the number of combinations (with repetitions) for a given number of items.
CONFIDENCE.NORM Returns the confidence interval for a population mean, using a normal distribution.
CONFIDENCE.T Returns the confidence interval for a population mean, using a Student's t distribution.
EXPON.DIST Returns the exponential distribution. Use EXPON.DIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPON.DIST to determine the probability that the process takes at most 1 minute.
GEOMEAN Returns geometric mean of given column reference.
GEOMEANX Returns geometric mean of an expression values in a table.
LINEST Uses the Least Squares method to calculate a straight line that best fits the data, then returns a table describing the line. The equation for the line is of the form: y = m1*x1 + m2*x2 + ... + b.
LINESTX Uses the Least Squares method to calculate a straight line that best fits the data, then returns a table describing the line. The data result from expressions evaluated for each row in a table.
MEDIAN Returns the 50th percentile of values in a column.
MEDIANX Returns the 50th percentile of an expression values in a table.
NORM.DIST Returns the normal distribution for the specified mean and standard deviation.
NORM.INV Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORM.S.DIST Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
NORM.S.INV Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
PERCENTILE.EXC Returns the k-th (exclusive) percentile of values in a column.
PERCENTILE.INC Returns the k-th (inclusive) percentile of values in a column.
PERCENTILEX.EXC Returns the k-th (exclusive) percentile of an expression values in a table.
PERCENTILEX.INC Returns the k-th (inclusive) percentile of an expression values in a table.
PERMUT Returns the number of permutations for a given number of objects that can be selected from number objects. A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from combinations, for which the internal order is not significant. Use this function for lottery-style probability calculations.
POISSON.DIST Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.
RANK.EQ Returns the rank of a number in a column of numbers. If more than one value has the same rank, the top rank of that set of values is returned.
RANKX Returns the rank of an expression evaluated in the current context in the list of values for the expression evaluated for each row in the specified table.
SAMPLE Returns a sample subset from a given table expression.
STDEV.P Calculates standard deviation based on the entire population given as arguments. Ignores logical values and text.
STDEV.S Estimates standard deviation based on a sample. Ignores logical values and text in the sample.
STDEVX.P Estimates standard deviation based on the entire population that results from evaluating an expression for each row of a table.
STDEVX.S Estimates standard deviation based on a sample that results from evaluating an expression for each row of a table.
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.
VAR.P Calculates variance based on the entire population. Ignores logical values and text in the population.
VAR.S Estimates variance based on a sample. Ignores logical values and text in the sample.
VARX.P Estimates variance based on the entire population that results from evaluating an expression for each row of a table.
VARX.S Estimates variance based on a sample that results from evaluating an expression for each row of a table.

Last update: Dec 4, 2024   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Daniel Otykier

2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us   » Privacy Policy & Cookies

Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

Row Context

This expression is executed in a Row Context. Click to read more.

Iterator

Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

Not recommended

The use of this parameter is not recommended.

Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

Volatile

A volatile function may return a different result every time you call it, even if you provide the same arguments. Click to read more.

Deprecated

This parameter is deprecated and its use is not recommended.

DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

Contribute

Want to improve the content of LINESTX? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.