Excel统计函数中比较常用的函数

Statistical functions

Statistical functions

AVEDEV Returns the average of the absolute deviations of data points from their mean

AVERAGE Returns the average of its arguments

AVERAGEA Returns the average of its arguments, including numbers, text, and logical values

BETADIST Returns the beta cumulative distribution function

BETAINV Returns the inverse of the cumulative distribution function for a specified beta distribution

BINOMDIST Returns the individual term binomial distribution probability

CHIDIST Returns the one-tailed probability of the chi-squared distribution

CHIINV Returns the inverse of the one-tailed probability of the chi-squared distribution

CHITEST Returns the test for independence

CONFIDENCE Returns the confidence interval for a population mean

CORREL Returns the correlation coefficient between two data sets

COUNT Counts how many numbers are in the list of arguments

COUNTA Counts how many values are in the list of arguments

COUNTBLANK Counts the number of blank cells within a range

COUNTIF Counts the number of nonblank cells within a range that meet the given criteria

COVAR Returns covariance, the average of the products of paired deviations

CRITBINOM Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value

DEVSQ Returns the sum of squares of deviations

EXPONDIST Returns the exponential distribution

FDIST Returns the F probability distribution

FINV Returns the inverse of the F probability distribution

FISHER Returns the Fisher transformation

FISHERINV Returns the inverse of the Fisher transformation

FORECAST Returns a value along a linear trend

FREQUENCY Returns a frequency distribution as a vertical array

FTEST Returns the result of an F-test

GAMMADIST Returns the gamma distribution

GAMMAINV Returns the inverse of the gamma cumulative distribution

GAMMALN Returns the natural logarithm of the gamma function, Γ(x)

GEOMEAN Returns the geometric mean

GROWTH Returns values along an exponential trend

HARMEAN Returns the harmonic mean

HYPGEOMDIST Returns the hypergeometric distribution

INTERCEPT Returns the intercept of the linear regression line

KURT Returns the kurtosis of a data set

LARGE Returns the k-th largest value in a data set

LINEST Returns the parameters of a linear trend

LOGEST Returns the parameters of an exponential trend

LOGINV Returns the inverse of the lognormal distribution

LOGNORMDIST Returns the cumulative lognormal distribution

MAX Returns the maximum value in a list of arguments

MAXA Returns the maximum value in a list of arguments, including numbers, text, and logical values

MEDIAN Returns the median of the given numbers

MIN Returns the minimum value in a list of arguments

MINA Returns the smallest value in a list of arguments, including numbers, text, and logical values

MODE Returns the most common value in a data set

NEGBINOMDIST Returns the negative binomial distribution

NORMDIST Returns the normal cumulative distribution

NORMINV Returns the inverse of the normal cumulative distribution

NORMSDIST Returns the standard normal cumulative distribution

NORMSINV Returns the inverse of the standard normal cumulative distribution

PEARSON Returns the Pearson product moment correlation coefficient

PERCENTILE Returns the k-th percentile of values in a range

PERCENTRANK Returns the percentage rank of a value in a data set

PERMUT Returns the number of permutations for a given number of objects

POISSON Returns the Poisson distribution

PROB Returns the probability that values in a range are between two limits

QUARTILE Returns the quartile of a data set

RANK Returns the rank of a number in a list of numbers

RSQ Returns the square of the Pearson product moment correlation coefficient

SKEW Returns the skewness of a distribution

SLOPE Returns the slope of the linear regression line

SMALL Returns the k-th smallest value in a data set

STANDARDIZE Returns 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

STEYX Returns the standard error of the predicted y-value for each x in the regression

TDIST Returns the Student\'s t-distribution

TINV Returns the inverse of the Student\'s t-distribution

TREND Returns values along a linear trend

TRIMMEAN Returns the mean of the interior of a data set

TTEST Returns the probability associated with a Student\'s t-test

VAR Estimates variance based on a sample

VARA Estimates variance based on a sample, including numbers, text, and logical values

VARP Calculates variance based on the entire population

VARPA Calculates variance based on the entire population, including numbers, text, and logical values

WEIBULL Returns the Weibull distribution

ZTEST Returns the one-tailed probability-value of a z-test

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/zzwzyp.html