[]
Spread provides the following statistical functions, listed alphabetically.
Function | Description |
---|---|
This function calculates the average of the absolute deviations of the specified values from their mean. | |
This function calculates the average of the specified numeric values. | |
This function calculates the average of the specified values, including text or logical values as well as numeric values. | |
This function calculates the average of the specified numeric values provided that they meet the specified criteria. | |
This function calculates the average of all cells that meet multiple specified criteria. | |
This function returns the beta distribution. | |
This function calculates the inverse of the cumulative beta distribution function. | |
This function calculates the individual term binomial distribution probability. | |
This function calculates the probability of a trial result using a binomial distribution. | |
This function returns the criterion binomial, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. | |
This function returns the chi-squared distribution. | |
This function calculates the one-tailed probability of the chi-squared distribution. | |
This function returns the inverse of left-tailed probability of the chi-squared distribution. | |
This function calculates the inverse of the one-tailed probability of the chi-squared distribution. | |
This function calculates the test for independence from the chi-squared distribution. | |
This function returns a confidence interval for a population mean. | |
This function returns the confidence interval for a Student's t distribution. | |
This function returns the correlation coefficient of the two sets of data. | |
This function returns the number of cells that contain numbers. | |
This function returns the number of cells that contain numbers, text, or logical values. | |
This function returns the number of empty (or blank) cells in a range of cells on a sheet. | |
This function returns the number of cells that meet a certain condition. | |
This function returns the number of cells that meet multiple conditions. | |
This function returns the covariance, which is the average of the products of deviations for each data point pair in two sets of numbers. | |
This function returns the sample covariance, which is the average of the products of deviations for each data point pair in two sets of numbers. | |
This function calculates the sum of the squares of deviations of data points (or of an array of data points) from their sample mean. | |
This function returns the exponential distribution or the probability density. | |
This function returns the F probability distribution. | |
This function calculates the F probability distribution, to see degrees of diversity between two sets of data. | |
This function returns the inverse of the F probability distribution. | |
This function returns the inverse of the F probability distribution. | |
This function returns the result of an F-test, which returns the one-tailed probability that the variances in two arrays are not significantly different. | |
This function returns the inverse of the F probability distribution. | |
This function returns the Fisher transformation for a specified value. | |
This function returns the inverse of the Fisher transformation for a specified value. | |
This function calculates a future value using existing values. | |
This function calculates how often values occur within a range of values. This function returns a vertical array of numbers. | |
This function returns the gamma function value. | |
This function returns the gamma distribution. | |
This function returns the inverse of the gamma cumulative distribution. | |
This function returns the natural logarithm of the Gamma function, G(x). | |
This function returns the natural logarithm of the gamma function. | |
This function calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean. | |
This function returns the geometric mean of a set of positive data. | |
This function calculates predicted exponential growth. This function returns the y values for a series of new x values that are specified by using existing x and y values. | |
This function returns the harmonic mean of a data set. | |
This function returns the hypergeometric distribution. | |
This function returns the coordinates of a point at which a line intersects the y-axis, by using existing x values and y values. | |
This function returns the kurtosis of a data set. | |
This function returns the nth largest value in a data set, where n is specified. | |
This function calculates the statistics for a line. | |
This function calculates an exponential curve that fits the data and returns an array of values that describes the curve. | |
This function returns the log-normal distribution of x. | |
This function returns the inverse of the lognormal cumulative distribution function of x, where LN(x) is normally distributed with the specified mean and standard deviation. | |
This function returns the maximum value, the greatest value, of all the values in the arguments. | |
This function returns the largest value in a list of arguments, including text and logical values. | |
This function returns the maximum value among cells specified by a given set of conditions or criteria. | |
This function returns the median, the number in the middle of the provided set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less than the median. | |
This function returns the minimum value, the least value, of all the values in the arguments. | |
This function returns the minimum value in a list of arguments, including text and logical values. | |
This function returns the minimum value among cells specified by a given set of conditions or criteria. | |
This function returns the most frequently occurring vertical array or the occurring value in a set of data. | |
This function returns the most frequently occurring value in a set of data. | |
This function returns the negative binomial distribution. | |
This function returns the normal cumulative distribution for the specified mean and standard deviation. | |
This function returns the standard normal distribution. | |
This function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one. | |
This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation. | |
This function returns the Pearson product moment correlation coefficient, a dimensionless index between -1.0 to 1.0 inclusive indicative of the linear relationship between two data sets. | |
This function returns the nth percentile of values in a range. | |
This function returns the nth percentile of values in a range. | |
This function returns the percentage rank(0..1, exclusive) of a value in a data set. | |
This function returns the rank of a value in a data set as a percentage of the data set. | |
This function returns the number of possible permutations for a specified number of items. | |
This function returns the number of permutations for a given number of objects that can be selected from the total objects. | |
This function returns the value of the density function for a standard normal distribution. | |
This function returns the Poisson distribution. | |
This function returns the probability that values in a range are between two limits. | |
This function returns which quartile (which quarter or 25 percent) of a data set a value is. | |
This function returns which quartile (which quarter or 25 percent) of a data set a value is. | |
This function returns the rank of a number in a set of numbers. If some values have the same rank, it will return the average rank. | |
This function returns the rank of a number in a set of numbers. If you were to sort the set, the rank of the number would be its position in the list. | |
This function returns the square of the Pearson product moment correlation coefficient (R-squared) through data points in known y's and known x's. | |
This function returns the skewness of a distribution. | |
This function returns the skewness of a distribution base on a population: characterization of the degree of asymmetry of a distribution around its mean. | |
This function calculates the slope of linear regression. | |
This function returns the nth smallest value in a data set, where n is specified. | |
This function returns a normalized value from a distribution characterized by mean and standard deviation. | |
This function returns the standard deviation for an entire specified population (of numeric values). | |
This function returns a standard deviation estimated based on a sample. | |
This function returns the standard deviation for a set of numbers, text, or logical values. | |
This function returns the standard deviation for an entire specified population, including text or logical values as well as numeric values. | |
This function returns the standard error of the predicted y value for each x. The standard error is a measure of the amount of error in the prediction of y for a value of x. | |
This function returns the t-distribution. | |
This function returns the two-tailed t-distribution. | |
This function returns the right-tailed t-distribution. | |
This function returns the left-tailed inverse of the t-distribution. | |
This function returns the t-value of the student's t-distribution as a function of the probability and the degrees of freedom. | |
This function returns the probability associated with a t-test. | |
This function returns values along with a linear trend. This function fits a straight line to the arrays known as x and y values. Trend returns the y values along that line for the array of specified new x values. | |
This function returns the mean of a subset of data excluding the top and bottom data. | |
This function returns variance based on the entire population, which uses only numeric values. | |
This function returns the variance based on a sample of a population, which uses only numeric values. | |
This function returns the variance based on a sample of a population, which includes numeric, logical, or text values. | |
This function returns variance based on the entire population, which includes numeric, logical, or text values. | |
This function returns the two-parameter Weibull distribution, often used in reliability analysis. | |
This function returns the significance value of a z-test. The z-test generates a standard score for x with respect to the set of data and returns the two-tailed probability for the normal distribution. |