Article Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set. Syntax AVEDEV ( number1...
Article Show All Hide All Returns the average (arithmetic mean) of the arguments. Syntax AVERAGE ( number1 ,number2,...) Number1, number2, ... are 1 to 30...
Article Calculates the average (arithmetic mean) of the values in the list of arguments. Syntax AVERAGEA ( value1 ,value2,...) Value1, value2, ... are 1 to 30...
Article Returns the cumulative beta probability density function. The beta distribution is commonly used to study variation in the percentage of something across...
Article Returns the inverse of the cumulative beta probability density function for a specified beta distribution. That is, if probability = BETADIST(x,...), then...
Article Returns the individual term binomial distribution probability. Use BINOMDIST in problems with a fixed number of tests or trials, when the outcomes of any...
Article Returns the one-tailed probability of the chi-squared distribution. The χ 2 distribution is associated with a χ 2 test. Use the χ 2 test to compare...
Article Returns the inverse of the one-tailed probability of the chi-squared distribution. If probability = CHIDIST(x,...), then CHIINV(probability,...) = x. Use...
Article Returns the test for independence. CHITEST returns the value from the chi-squared (χ 2 ) distribution for the statistic and the appropriate degrees of freedom...
Article Returns a value that you can use to construct a confidence interval for a population mean. The confidence interval is a range of values. Your sample mean...
Article Returns the correlation coefficient of the array1 and array2 cell ranges. Use the correlation coefficient to determine the relationship between two properties...
Article Syntax: COUNT(value1,value2,...)
Article Show All Hide All Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that...
Article Show All Hide All Counts empty cells in a specified range of cells. Syntax COUNTBLANK ( range ) Range is the range from which you want to count the...
Article Syntax: COUNTIF(range,criteria)
Article Show All Hide All Returns covariance, the average of the products of deviations for each data point pair. Use covariance to determine the relationship between...
Article Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Use this function for quality assurance...
Article Show All Hide All Returns the sum of squares of deviations of data points from their sample mean. Syntax DEVSQ ( number1 ,number2,...) Number1, number2...
Article Show All Hide All Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes...
Article Returns the F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you...
Article Returns the inverse of the F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x. The F distribution can be used in an F-test that compares...
Article Returns the Fisher transformation at x. This transformation produces a function that is normally distributed rather than skewed. Use this function to perform...
Article Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x...
Article Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x...
Article Calculates how often values occur within a range of values, and then returns a vertical array of numbers. For example, use FREQUENCY to count the number...
