Status | Function | Description |
|---|---|---|
Not started | BETA.DIST | Returns the beta distribution. |
Not started | BETA.INV | Returns the inverse of the beta cumulative probability density function (BETA.DIST). |
Not started | CHISQ.DIST | Returns the chi-squared distribution. |
Not started | CHISQ.DIST.RT | Returns the right-tailed probability of the chi-squared distribution. |
Not started | CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution. |
Not started | CHISQ.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared distribution. |
Not started | COMBIN | Returns the number of combinations for a given number of items. |
Not started | COMBINA | Returns the number of combinations (with repetitions) for a given number of items. |
Not started | CONFIDENCE.NORM | The confidence interval is a range of values. |
Not started | CONFIDENCE.T | Returns the confidence interval for a population mean, using a Student's t distribution. |
Not started | EXPON.DIST | Returns the exponential distribution. |
Not started | GEOMEAN | Returns the geometric mean of the numbers in a column. |
Not started | GEOMEANX | Returns the geometric mean of an expression evaluated for each row in a table. |
Not started | LINEST | Uses the Least Squares method to calculate a straight line that best fits the given data. |
Not started | 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. |
Not started | MEDIAN | Returns the median of numbers in a column. |
Not started | MEDIANX | Returns the median number of an expression evaluated for each row in a table. |
Not started | NORM.DIST | Returns the normal distribution for the specified mean and standard deviation. |
Not started | NORM.INV | The inverse of the normal cumulative distribution for the specified mean and standard deviation. |
Not started | NORM.S.DIST | Returns the standard normal distribution (has a mean of zero and a standard deviation of one). |
Not started | NORM.S.INV | Returns the inverse of the standard normal cumulative distribution. |
Not started | PERCENTILE.EXC | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. |
Not started | PERCENTILE.INC | Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive. |
Not started | PERCENTILEX.EXC | Returns the percentile number of an expression evaluated for each row in a table. |
Not started | PERCENTILEX.INC | Returns the percentile number of an expression evaluated for each row in a table. |
Not started | PERMUT | Returns the number of permutations for a given number of objects that can be selected from number objects. |
Not started | POISSON.DIST | Returns the Poisson distribution. |
Not started | RANK.EQ | Returns the ranking of a number in a list of numbers. |
Not started | RANKX | Returns the ranking of a number in a list of numbers for each row in the |
Not started | SAMPLE | Returns a sample of N rows from the specified table. |
Not started | STDEV.P | Returns the standard deviation of the entire population. |
Not started | STDEV.S | Returns the standard deviation of a sample population. |
Not started | STDEVX.P | Returns the standard deviation of the entire population. |
Not started | STDEVX.S | Returns the standard deviation of a sample population. |
Not started | T.DIST | Returns the Student's left-tailed t-distribution. |
Not started | T.DIST.2T | Returns the two-tailed Student's t-distribution. |
Not started | T.DIST.RT | Returns the right-tailed Student's t-distribution. |
Not started | T.INV | Returns the left-tailed inverse of the Student's t-distribution. |
Not started | T.INV.2t | Returns the two-tailed inverse of the Student's t-distribution. |
Not started | VAR.P | Returns the variance of the entire population. |
Not started | VAR.S | Returns the variance of a sample population. |
Not started | VARX.P | Returns the variance of the entire population. |
Not started | VARX.S | Returns the variance of a sample population. |