Statistical Functions Flashcards
SAMPLE(n_value, table, orderBy_expression, [order[, orderBy_expression, [order]]…])
Returns a sample of N rows from the specified table.
BETA.DIST(x,alpha,beta,cumulative,[A],[B])
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.
CHISQ.DIST(x, deg_freedom, cumulative)
Returns the chi-squared distribution.
CONFIDENCE.T(alpha,standard_dev,size)
Returns the confidence interval for a population mean, using a Student’s t distribution.
EXPON.DIST(x,lambda,cumulative)
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.
GEOMEANX(table, expression)
Returns the geometric mean of an expression evaluated for each row in a table.
GEOMEAN(column)
Returns the geometric mean of the numbers in a column.
BETA.INV(probability,alpha,beta,[A],[B])
Returns the inverse of the beta cumulative probability density function (BETA.DIST).
CHISQ.INV(probability,deg_freedom)
Returns the inverse of the left-tailed probability of the chi-squared distribution.
CHISQ.INV.RT(probability,deg_freedom)
Returns the inverse of the right-tailed probability of the chi-squared distribution.
NORM.S.INV(Probability)
Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
PERCENTILE.EXC(column, k)
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INC(column, k)
Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
T.INV(Probability,Deg_freedom)
Returns the left-tailed inverse of the Student’s t-distribution.
MEDIANX(table, expression)
Returns the median number of an expression evaluated for each row in a table.
MEDIAN(column)
Returns the median of numbers in a column.
NORM.DIST(X, Mean, Standard_dev, Cumulative)
Returns the normal distribution for the specified mean and standard deviation.
COMBINA(number, number_chosen)
Returns the number of combinations (with repetitions) for a given number of items.
COMBIN(number, number_chosen)
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.
PERMUT(number, number_chosen)
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.
PERCENTILEX.EXC(table, expression, k)
Returns the percentile number of an expression evaluated for each row in a table.
PERCENTILEX.INC(table, expression;, k)
Returns the percentile number of an expression evaluated for each row in a table.
POISSON.DIST(x,mean,cumulative)
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.
RANKX(table, expression[, value[, order[, ties]]])
Returns the ranking of a number in a list of numbers for each row in the table argument.