# Statistical functions

Statistical functions calculate values related to statistical distributions and probability, such as standard deviation and number of permutations.

## In this category

Function | Description |
---|---|

BETA.DIST | Returns the beta distribution. |

BETA.INV | Returns the inverse of the beta cumulative probability density function (BETA.DIST). |

CHISQ.DIST | Returns the chi-squared distribution. |

CHISQ.DIST.RT | Returns the right-tailed probability of the chi-squared distribution. |

CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution. |

CHISQ.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared distribution. |

COMBIN | Returns the number of combinations for a given number of items. |

COMBINA | Returns the number of combinations (with repetitions) for a given number of items. |

CONFIDENCE.NORM | The confidence interval is a range of values. |

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

EXPON.DIST | Returns the exponential distribution. |

GEOMEAN | Returns the geometric mean of the numbers in a column. |

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

LINEST | Uses the Least Squares method to calculate a straight line that best fits the given data. |

LINESTX | Uses the Least Squares method to calculate a straight line that best fits the given data. The data result from expressions evaluated for each row in a table. |

MEDIAN | Returns the median of numbers in a column. |

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

NORM.DIST | Returns the normal distribution for the specified mean and standard deviation. |

NORM.INV | 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. |

PERCENTILE.EXC | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. |

PERCENTILE.INC | Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive. |

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

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

PERMUT | Returns the number of permutations for a given number of objects that can be selected from number objects. |

POISSON.DIST | Returns the Poisson distribution. |

RANK.EQ | Returns the ranking of a number in a list of numbers. |

RANKX | Returns the ranking of a number in a list of numbers for each row in the table argument. |

SAMPLE | Returns a sample of N rows from the specified table. |

STDEV.P | Returns the standard deviation of the entire population. |

STDEV.S | Returns the standard deviation of a sample population. |

STDEVX.P | Returns the standard deviation of the entire population. |

STDEVX.S | Returns the standard deviation of a sample population. |

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

## Feedback

https://aka.ms/ContentUserFeedback.

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for