Article Returns the most frequently occurring, or repetitive, value in the argument list. Like MEDIAN, MODE is a location measure. Syntax MODE ( number1 , number2 , ......

Article Returns the smallest value in the list of arguments. Text and logical values such as TRUE and FALSE are compared as well as numbers. Syntax MINA ( value1 , valu...

Article Returns the smallest number in a set of values. Syntax MIN ( number1 , number2 , ... ) Number1, number2,...   are 1 to 30 numbers for which you want to find the...

Article Returns the median of the given numbers. The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than...

Article Returns the largest value in a set of values. Syntax MAX ( number1 , number2 , ... ) Number1,number2,...   are 1 to 30 numbers for which you want to find the ma...

Article Returns the largest value in a list of arguments. Text and logical values such as TRUE and FALSE are compared as well as numbers. MAXA is similar to MINA. For m...

Article Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LO...

Article Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with the parameters mean and standard_dev. Use this function to analyze ...

Article Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive...

Article Returns the hypergeometric distribution. HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes,...

Article Returns the natural logarithm of the gamma function, Γ(x). Syntax GAMMALN ( x ) X   is the value for which you want to calculate GAMMALN. Remarks If x is nonnum...

Article Returns the geometric mean of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with variable rates. Synt...

Article Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in que...

Article Returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals. Syntax HARMEAN ( number1 , number2 , ... ) N...

Article Returns the inverse of the gamma cumulative distribution. If p = GAMMADIST(x,...), then GAMMAINV(p,...) = x. You can use this function to study a variable whose...

Article Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then F...

Article Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure. Syntax WEIBULL ( x , alpha...

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 the ...

Article Calculates variance based on the entire population. In addition to numbers, text and logical values such as TRUE and FALSE are included in the calculation. Synt...

Article Estimates variance based on a sample. In addition to numbers, text and logical values such as TRUE and FALSE are included in the calculation. Syntax VARA ( valu...

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 can e...

Article Estimates variance based on a sample. Syntax VAR ( number1 , number2 , ... ) Number1,number2,...   are 1 to 30 number arguments corresponding to a sample of a p...

Article Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For examp...

Article Calculates variance based on the entire population. Syntax VARP ( number1 , number2 , ... ) Number1,number2, ...   are 1 to 30 number arguments corresponding t...

Article Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. Syntax TINV ( probability , degrees_freedom ) P...