✔ Programação GLOBAL®: Excel Tips - Funções de Estatística

Tenham em mente que elas estão expressas em inglês, escolhi assim para que pudéssemos ter proveito delas tanto funcionalmente no MS Excel quanto na programação VBA. Sei que na maioria das empresas a instalação está em português, o que pessoalmente acho péssimo, nestes casos poderá procurar pela referência de como escrevê-la em Português.

Ahh e não reclamem, aproveitem para usar o Google Translate se precisarem.

Funções de Estatística

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

AVERAGEIF

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria

AVERAGEIFS

Returns the average (arithmetic mean) of all cells that meet multiple criteria.

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 cells within a range that meet the given criteria.

COUNTIFS

Counts the number of cells within a range that meet multiple 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.