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.
Funções de Estatística
AVEDEVReturns the average of the absolute deviations of data points from their meanAVERAGEReturns the average of its argumentsAVERAGEAReturns the average of its arguments, including numbers, text, and logical valuesAVERAGEIFReturns the average (arithmetic mean) of all the cells in a range that meet a given criteriaAVERAGEIFSReturns the average (arithmetic mean) of all cells that meet multiple criteria.BETADISTReturns the beta cumulative distribution function.BETAINVReturns the inverse of the cumulative distribution function for a specified beta distribution.BINOMDISTReturns the individual term binomial distribution probability.CHIDISTReturns the one-tailed probability of the chi-squared distribution.CHIINVReturns the inverse of the one-tailed probability of the chi-squared distribution.CHITESTReturns the test for independence.CONFIDENCEReturns the confidence interval for a population mean.CORRELReturns the correlation coefficient between two data sets.COUNTCounts how many numbers are in the list of arguments.COUNTACounts how many values are in the list of arguments.COUNTBLANKCounts the number of blank cells within a range.COUNTIFCounts the number of cells within a range that meet the given criteria.COUNTIFSCounts the number of cells within a range that meet multiple criteria.COVARReturns covariance, the average of the products of paired deviations.CRITBINOMReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.DEVSQReturns the sum of squares of deviations.EXPONDISTReturns the exponential distribution.FDISTReturns the F probability distribution.FINVReturns the inverse of the F probability distribution.FISHERReturns the Fisher transformation.FISHERINVReturns the inverse of the Fisher transformation.FORECASTReturns a value along a linear trend.FREQUENCYReturns a frequency distribution as a vertical array.FTESTReturns the result of an F-test.GAMMADISTReturns the gamma distribution.GAMMAINVReturns the inverse of the gamma cumulative distribution.GAMMALNReturns the natural logarithm of the gamma function, Γ(x).GEOMEANReturns the geometric mean.GROWTHReturns values along an exponential trend.HARMEANReturns the harmonic mean.HYPGEOMDISTReturns the hypergeometric distribution.INTERCEPTReturns the intercept of the linear regression line.KURTReturns the kurtosis of a data set.LARGEReturns the k-th largest value in a data set.LINESTReturns the parameters of a linear trend.LOGESTReturns the parameters of an exponential trend.LOGINVReturns the inverse of the lognormal distribution.LOGNORMDISTReturns the cumulative lognormal distribution.MAXReturns the maximum value in a list of arguments.MAXAReturns the maximum value in a list of arguments, including numbers, text, and logical values.MEDIANReturns the median of the given numbers.MINReturns the minimum value in a list of arguments.MINAReturns the smallest value in a list of arguments, including numbers, text, and logical values.MODEReturns the most common value in a data set.NEGBINOMDISTReturns the negative binomial distribution.NORMDISTReturns the normal cumulative distribution.NORMINVReturns the inverse of the normal cumulative distribution.NORMSDISTReturns the standard normal cumulative distribution.NORMSINVReturns the inverse of the standard normal cumulative distribution.PEARSONReturns the Pearson product moment correlation coefficient.PERCENTILEReturns the k-th percentile of values in a range.PERCENTRANKReturns the percentage rank of a value in a data set.PERMUTReturns the number of permutations for a given number of objects.POISSONReturns the Poisson distribution.PROBReturns the probability that values in a range are between two limits.QUARTILEReturns the quartile of a data set.RANKReturns the rank of a number in a list of numbers.RSQReturns the square of the Pearson product moment correlation coefficient.SKEWReturns the skewness of a distribution.SLOPEReturns the slope of the linear regression line.SMALLReturns the k-th smallest value in a data set.STANDARDIZEReturns a normalized value.STDEVEstimates standard deviation based on a sample.STDEVAEstimates standard deviation based on a sample, including numbers, text, and logical values.STDEVPCalculates standard deviation based on the entire population.STDEVPACalculates standard deviation based on the entire population, including numbers, text, and logical values.STEYXReturns the standard error of the predicted y-value for each x in the regression.TDISTReturns the Student's t-distribution.TINVReturns the inverse of the Student's t-distribution.TRENDReturns values along a linear trend.TRIMMEANReturns the mean of the interior of a data set.TTESTReturns the probability associated with a Student's t-test.VAREstimates variance based on a sample.VARAEstimates variance based on a sample, including numbers, text, and logical values.VARPCalculates variance based on the entire population.VARPACalculates variance based on the entire population, including numbers, text, and logical values.WEIBULLReturns the Weibull distribution.ZTESTReturns the one-tailed probability-value of a z-test.
Tags: Function, Excel, Tips, functions, Estatística, Statistical
Nenhum comentário:
Postar um comentário