Page 393 - Fundamentals of Probability and Statistics for Engineers

376 Fundamentals of Probability and Statistics for Engineers

GAMMADIST: gives the gamma distribution
GAMMAINV: gives the inverse of the gamma distribution function
GAMMALN: gives the natural logarithm of the gamma function
GEOMEAN: gives the geometric mean
GROWTH: gives values along an exponential trend
HYPGEOMDIST: gives the hypergeometric distribution
INTERCEPT: gives the intercept of the linear regression line
KURT: gives the kurtosis of a data set
LARGE: gives the kth largest value in a data set
LINEST: gives the parameters of a linear trend
LOGEST: gives the parameters of an exponential trend
LOGINV: gives the inverse of the lognormal distribution
LOGNORMDIST: gives the lognormal distribution function
MAX: gives the maximum value in a list of arguments
MAXA: gives the maximum value in a list of arguments, including numbers,
text, and logical values
MEDIAN: gives the median of the given numbers
MIN: gives the minimum value in a list of arguments
MINA: gives the smallest value in a list of arguments, including numbers, text,
and logical values
MODE: gives the most common value in a data set
NEGBINOMDIST: gives the negative binomial distribution
NORMDIST: gives the normal distribution function
NORMINV: gives the inverse of the normal distribution function
NORMSDIST: gives the standardized normal distribution function
NORMSINV: gives the inverse of the standardized normal distribution function
PERCENTILE: gives the kth percentile of values in a range
PERCENTRANK: gives the percentage rank of a value in a data set
PERMUT: gives the number of permutations for a given number of objects
POISSON: gives the Poisson distribution
PROB: gives the probability that values in a range are between two limits
QUARTILE: gives the quartile of a data set
RANK: gives the rank of a number in a list of numbers
SKEW: gives the skewness of a distribution
SLOPE: gives the slope of the linear regression line
SMALL: gives the kth smallest value in a data set
STANDARDIZE: gives a normalized value
STDEV: estimates standard deviation based on a sample
STDEVA: estimates standard deviation based on a sample, including numbers,
text, and logical values
STDEVP: calculates standard deviation based on the entire population
STDEVPA: calculates standard deviation based on the entire population,
including numbers, text, and logical values

TLFeBOOK