Title: Theory / Unimportant / CS / Softw / Website / Google / Sheets / Statistical
On every note of this deck, unless a note says otherwise:
Page: https://support.google.com/docs/table/25273?hl=en
Language: Sheets
Context: Statistical

Instruction: AVEDEV(value1, [value2, ...])
Returns: Calculates the average of the magnitudes of deviations of data from a dataset's mean. Learn more

Instruction: AVERAGE(value1, [value2, ...])
Returns: Returns the numerical average value in a dataset, ignoring text. Learn more

Instruction: AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])
Returns: Finds the weighted average of a set of values, given the values and the corresponding weights. Learn more.

Instruction: AVERAGEA(value1, [value2, ...])
Returns: Returns the numerical average value in a dataset. Learn more

Instruction: AVERAGEIF(criteria_range, criterion, [average_range])
Returns: Returns the average of a range depending on criteria. Learn more

Instruction: AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns: Returns the average of a range depending on multiple criteria. Learn more

Instruction: BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound)
Returns: Returns the probability of a given value as defined by the beta distribution function. Learn more.

Instruction: BETA.INV(probability, alpha, beta, lower_bound, upper_bound)
Returns: Returns the value of the inverse beta distribution function for a given probability. Learn more.

Instruction: BETADIST(value, alpha, beta, lower_bound, upper_bound)
Returns: See BETA.DIST.

Instruction: BETAINV(probability, alpha, beta, lower_bound, upper_bound)
Returns: See BETA.INV

Instruction: BINOM.DIST(num_successes, num_trials, prob_success, cumulative)
Returns: See BINOMDIST

Instruction: BINOM.INV(num_trials, prob_success, target_prob)
Returns: See CRITBINOM

Instruction: BINOMDIST(num_successes, num_trials, prob_success, cumulative)
Returns: Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws. Learn more

Instruction: CHIDIST(x, degrees_freedom)
Returns: Calculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn more

Instruction: CHIINV(probability, degrees_freedom)
Returns: Calculates the inverse of the right-tailed chi-squared distribution. Learn more

Instruction: CHISQ.DIST(x, degrees_freedom, cumulative)
Returns: Calculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn more

Instruction: CHISQ.DIST.RT(x, degrees_freedom)
Returns: Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing. Learn more

Instruction: CHISQ.INV(probability, degrees_freedom)
Returns: Calculates the inverse of the left-tailed chi-squared distribution. Learn more

Instruction: CHISQ.INV.RT(probability, degrees_freedom)
Returns: Calculates the inverse of the right-tailed chi-squared distribution. Learn more

Instruction: CHISQ.TEST(observed_range, expected_range)
Returns: See CHITEST

Instruction: CHITEST(observed_range, expected_range)
Returns: Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution. Learn more

Instruction: CONFIDENCE(alpha, standard_deviation, pop_size)
Returns: See CONFIDENCE.NORM

Instruction: CONFIDENCE.NORM(alpha, standard_deviation, pop_size)
Returns: Calculates the width of half the confidence interval for a normal distribution. Learn more.

Instruction: CONFIDENCE.T(alpha, standard_deviation, size)
Returns: Calculates the width of half the confidence interval for a Student’s t-distribution. Learn more.

Instruction: CORREL(data_y, data_x)
Returns: Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more

Instruction: COUNT(value1, [value2, ...])
Returns: Returns a count of the number of numeric values in a dataset. Learn more

Instruction: COUNTA(value1, [value2, ...])
Returns: Returns a count of the number of values in a dataset. Learn more

Instruction: COVAR(data_y, data_x)
Returns: Calculates the covariance of a dataset. Learn more

Instruction: COVARIANCE.P(data_y, data_x)
Returns: See COVAR

Instruction: COVARIANCE.S(data_y, data_x)
Returns: Calculates the covariance of a dataset, where the dataset is a sample of the total population. Learn more.

Instruction: CRITBINOM(num_trials, prob_success, target_prob)
Returns: Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn more

Instruction: DEVSQ(value1, value2)
Returns: Calculates the sum of squares of deviations based on a sample. Learn more

Instruction: EXPON.DIST(x, LAMBDA, cumulative)
Returns: Returns the value of the exponential distribution function with a specified LAMBDA at a specified value. Learn more.

Instruction: EXPONDIST(x, LAMBDA, cumulative)
Returns: See EXPON.DIST

Instruction: F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)
Returns: Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more

Instruction: F.DIST.RT(x, degrees_freedom1, degrees_freedom2)
Returns: Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more

Instruction: F.INV(probability, degrees_freedom1, degrees_freedom2)
Returns: Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more

Instruction: F.INV.RT(probability, degrees_freedom1, degrees_freedom2)
Returns: Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more

Instruction: F.TEST(range1, range2)
Returns: See FTEST.

Instruction: FDIST(x, degrees_freedom1, degrees_freedom2)
Returns: See F.DIST.RT.

Instruction: FINV(probability, degrees_freedom1, degrees_freedom2)
Returns: See F.INV.RT

Instruction: FISHER(value)
Returns: Returns the Fisher transformation of a specified value. Learn more

Instruction: FISHERINV(value)
Returns: Returns the inverse Fisher transformation of a specified value. Learn more

Instruction: FORECAST(x, data_y, data_x)
Returns: Calculates the expected y-value for a specified x based on a linear regression of a dataset. Learn more

Instruction: FORECAST.LINEAR(x, data_y, data_x)
Returns: See FORECAST

Instruction: FTEST(range1, range2)
Returns: Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance. Learn more

Instruction: GAMMA(number)
Returns: Returns the Gamma function evaluated at the specified value. Learn more.

Instruction: GAMMA.DIST(x, alpha, beta, cumulative)
Returns: Calculates the gamma distribution, a two-parameter continuous probability distribution. Learn more

Instruction: GAMMA.INV(probability, alpha, beta)
Returns: The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters. Learn more.

Instruction: GAMMADIST(x, alpha, beta, cumulative)
Returns: See GAMMA.DIST

Instruction: GAMMAINV(probability, alpha, beta)
Returns: See GAMMA.INV.

Instruction: GAUSS(z)
Returns: The GAUSS function returns the probability that a random variable, drawn from a normal distribution, will be between the mean and z standard deviations above (or below) the mean. Learn more.

Instruction: GEOMEAN(value1, value2)
Returns: Calculates the geometric mean of a dataset. Learn more

Instruction: HARMEAN(value1, value2)
Returns: Calculates the harmonic mean of a dataset. Learn more

Instruction: HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)
Returns: See HYPGEOMDIST

Instruction: HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)
Returns: Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws. Learn more

Instruction: INTERCEPT(data_y, data_x)
Returns: Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0). Learn more

Instruction: KURT(value1, value2)
Returns: Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset. Learn more

Instruction: LARGE(data, n)
Returns: Returns the nth largest element from a data set, where n is user-defined. Learn more

Instruction: LOGINV(x, mean, standard_deviation)
Returns: Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more

Instruction: LOGNORM.DIST(x, mean, standard_deviation)
Returns: See LOGNORMDIST

Instruction: LOGNORM.INV(x, mean, standard_deviation)
Returns: See LOGINV

Instruction: LOGNORMDIST(x, mean, standard_deviation)
Returns: Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more

Instruction: MAX(value1, [value2, ...])
Returns: Returns the maximum value in a numeric dataset. Learn more

Instruction: MAXA(value1, value2)
Returns: Returns the maximum numeric value in a dataset. Learn more

Instruction: MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
Returns: Returns the maximum value in a range of cells, filtered by a set of criteria. Learn more.

Instruction: MEDIAN(value1, [value2, ...])
Returns: Returns the median value in a numeric dataset. Learn more

Instruction: MIN(value1, [value2, ...])
Returns: Returns the minimum value in a numeric dataset. Learn more

Instruction: MINA(value1, value2)
Returns: Returns the minimum numeric value in a dataset. Learn more

Instruction: MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
Returns: Returns the minimum value in a range of cells, filtered by a set of criteria. Learn more.

Instruction: MODE(value1, [value2, ...])
Returns: Returns the most commonly occurring value in a dataset. Learn more

Instruction: MODE.MULT(value1, value2)
Returns: Returns the most commonly occurring values in a dataset. Learn more.

Instruction: MODE.SNGL(value1, [value2, ...])
Returns: See MODE

Instruction: NEGBINOM.DIST(num_failures, num_successes, prob_success)
Returns: See NEGBINOMDIST

Instruction: NEGBINOMDIST(num_failures, num_successes, prob_success)
Returns: Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials. Learn more

Instruction: NORM.DIST(x, mean, standard_deviation, cumulative)
Returns: See NORMDIST

Instruction: NORM.INV(x, mean, standard_deviation)
Returns: See NORMINV

Instruction: NORM.S.DIST(x)
Returns: See NORMSDIST

Instruction: NORM.S.INV(x)
Returns: See NORMSINV

Instruction: NORMDIST(x, mean, standard_deviation, cumulative)
Returns: Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation. Learn more

Instruction: NORMINV(x, mean, standard_deviation)
Returns: Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation. Learn more

Instruction: NORMSDIST(x)
Returns: Returns the value of the standard normal cumulative distribution function for a specified value. Learn more

Instruction: NORMSINV(x)
Returns: Returns the value of the inverse standard normal distribution function for a specified value. Learn more

Instruction: PEARSON(data_y, data_x)
Returns: Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more

Instruction: PERCENTILE(data, percentile)
Returns: Returns the value at a given percentile of a dataset. Learn more

Instruction: PERCENTILE.EXC(data, percentile)
Returns: Returns the value at a given percentile of a dataset, exclusive of 0 and 1. Learn more.

Instruction: PERCENTILE.INC(data, percentile)
Returns: See PERCENTILE

Instruction: PERCENTRANK(data, value, [significant_digits])
Returns: Returns the percentage rank (percentile) of a specified value in a dataset. Learn more

Instruction: PERCENTRANK.EXC(data, value, [significant_digits])
Returns: Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset. Learn more

Instruction: PERCENTRANK.INC(data, value, [significant_digits])
Returns: Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset. Learn more

Instruction: PERMUTATIONA(number, number_chosen)
Returns: Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. Learn more.

Instruction: PERMUT(n, k)
Returns: Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order. Learn more

Instruction: PHI(x)
Returns: The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1. Learn more.

Instruction: POISSON(x, mean, cumulative)
Returns: See POISSON.DIST

Instruction: POISSON.DIST(x, mean, [cumulative])
Returns: Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. Learn more.

Instruction: PROB(data, probabilities, low_limit, [high_limit])
Returns: Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits. Learn more

Instruction: QUARTILE(data, quartile_number)
Returns: Returns a value nearest to a specified quartile of a dataset. Learn more

Instruction: QUARTILE.EXC(data, quartile_number)
Returns: Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4. Learn more.

Instruction: QUARTILE.INC(data, quartile_number)
Returns: See QUARTILE

Instruction: RANK(value, data, [is_ascending])
Returns: Returns the rank of a specified value in a dataset. Learn more

Instruction: RANK.AVG(value, data, [is_ascending])
Returns: Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned. Learn more

Instruction: RANK.EQ(value, data, [is_ascending])
Returns: Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned. Learn more

Instruction: RSQ(data_y, data_x)
Returns: Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset. Learn more

Instruction: SKEW(value1, value2)
Returns: Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean. Learn more

Instruction: SKEW.P(value1, value2)
Returns: Calculates the skewness of a dataset that represents the entire population. Learn more.

Instruction: SLOPE(data_y, data_x)
Returns: Calculates the slope of the line resulting from linear regression of a dataset. Learn more

Instruction: SMALL(data, n)
Returns: Returns the nth smallest element from a data set, where n is user-defined. Learn more

Instruction: STANDARDIZE(value, mean, standard_deviation)
Returns: Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution. Learn more

Instruction: STDEV(value1, [value2, ...])
Returns: Calculates the standard deviation based on a sample. Learn more

Instruction: STDEV.P(value1, [value2, ...])
Returns: See STDEVP

Instruction: STDEV.S(value1, [value2, ...])
Returns: See STDEV

Instruction: STDEVA(value1, value2)
Returns: Calculates the standard deviation based on a sample, setting text to the value `0`. Learn more

Instruction: STDEVP(value1, value2)
Returns: Calculates the standard deviation based on an entire population. Learn more

Instruction: STDEVPA(value1, value2)
Returns: Calculates the standard deviation based on an entire population, setting text to the value `0`. Learn more

Instruction: STEYX(data_y, data_x)
Returns: Calculates the standard error of the predicted y-value for each x in the regression of a dataset. Learn more

Instruction: T.DIST(x, degrees_freedom, cumulative)
Returns: Returns the right tailed Student distribution for a value x. Learn more.

Instruction: T.DIST.2T(x, degrees_freedom)
Returns: Returns the two tailed Student distribution for a value x. Learn more.

Instruction: T.DIST.RT(x, degrees_freedom)
Returns: Returns the right tailed Student distribution for a value x. Learn more.

Instruction: T.INV(probability, degrees_freedom)
Returns: Calculates the negative inverse of the one-tailed TDIST function. Learn more

Instruction: T.INV.2T(probability, degrees_freedom)
Returns: Calculates the inverse of the two-tailed TDIST function. Learn more

Instruction: T.TEST(range1, range2, tails, type)
Returns: Returns the probability associated with Student's t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. Learn more.

Instruction: TDIST(x, degrees_freedom, tails)
Returns: Calculates the probability for Student's t-distribution with a given input (x). Learn more

Instruction: TINV(probability, degrees_freedom)
Returns: See T.INV.2T

Instruction: TRIMMEAN(data, exclude_proportion)
Returns: Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset. Learn more

Instruction: TTEST(range1, range2, tails, type)
Returns: See T.TEST.

Instruction: VAR(value1, [value2, ...])
Returns: Calculates the variance based on a sample. Learn more

Instruction: VAR.P(value1, [value2, ...])
Returns: See VARP

Instruction: VAR.S(value1, [value2, ...])
Returns: See VAR

Instruction: VARA(value1, value2)
Returns: Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more

Instruction: VARP(value1, value2)
Returns: Calculates the variance based on an entire population. Learn more

Instruction: VARPA(value1, value2,...)
Returns: Calculates the variance based on an entire population, setting text to the value `0`. Learn more

Instruction: WEIBULL(x, shape, scale, cumulative)
Returns: Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. Learn more

Instruction: WEIBULL.DIST(x, shape, scale, cumulative)
Returns: See WEIBULL

Instruction: Z.TEST(data, value, [standard_deviation])
Returns: Returns the one-tailed P-value of a Z-test with standard distribution. Learn more.

Instruction: ZTEST(data, value, [standard_deviation])
Returns: See Z.TEST.