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: Nov 14, 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