Views

Important:

Quaisquer necessidades de soluções e/ou desenvolvimento de aplicações pessoais/profissionais, que não constem neste Blog podem ser tratados como consultoria freelance à parte.

...

1 de abril de 2013

Excel Tips - Funções de Estatística - Statistical functions

Inline image 1

Para utilizarmos bem as funções do MS Excel precisamos ao menos saber que existem e conhecermos onde as podemos aplicar.

O que segue são algumas destas que podemos utilizar extensivamente, agora com um pouco mais de conhecimento.

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.


Tags: Function, Excel, Tips, functions, Estatística, Statistical

Nenhum comentário:

Postar um comentário

eBooks VBA na AMAZOM.com.br

Vitrine