Page 266 - Excel Data Analysis

14 537547 AppB.qxd 3/4/03 11:57 AM Page 252

APPENDIX

EXCEL FUNCTION QUICK REFERENCE

(CONTINUED)

STATISTICAL FUNCTIONS (CONTINUED)

FUNCTION DESCRIPTION
CRITBINOM(trials, probability_s, alpha) Finds the smallest value for the cumulative binomial distribution.
DEVSQ(number1[, number2,...]) Sums the squares of the deviations between the specified values.
EXPONDIST(x, lambda, cumulative) Finds the exponential distribution.
FDIST(x, degrees_freedom1, degrees_freedom2) Finds the F probability distribution.
FINV(probability, degrees_freedom1, Finds the inverse of the F probability distribution.
degrees_freedom2)
FISHER(x) Calculates the Fisher transformation of the specified value.
FISHERINV(y) Calculates the inverse of the Fisher transformation of the
specified value.
FORECAST(x, known_y's, known_x's) Predicts a future value based upon the existing values.
FREQUENCY(data_array, bins_array) Determines the number of times specific values occur within a
range.
FTEST(array1, array2) Compares two arrays and determines if the variances are equal.
GAMMADIST(x, alpha, beta, cumulative) Finds the gamma distribution.
GAMMAINV(probability, alpha, beta, cumulative) Finds the inverse of the gamma distribution.
GAMMALN(x) Finds the natural logarithm of the gamma function.
GEOMEAN(number1[, number2,...]) Determines the geometric mean of the specified values.
GROWTH(known_y's[, known_x's, new_x's, const]) Finds the future exponential growth.
HARMEAN(number1[, number2,...]) Determines the harmonic mean of the specified values.
HYPGEOMDIST(sample_s, number_sample, Determines the probability of the specified number of successes
population_s, number_population) based upon the population size.
INTERCEPT(x, known_y's, known_x's) Determines the point where the line crosses the Y-axis.
KURT(number1[, number2,...]) Determines the kurtosis of the specified values.
LARGE(array, k) Finds the value that is the specified number within an array
based upon its size.
LINEST(known_y's[, known_x's, const, stats]) Finds the best-fitting straight line using the least squares method.

252