Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical

 
AVEDEVThe average deviation for a list of numbers.
AVERAGEThe arithmetic mean of a list or array of numbers.
AVERAGEAThe arithmetic mean of a list or array of numbers, including text and logical values.
BETADISTThe cumulative beta probability density function.
BETAINVThe inverse of the cumulative beta probability density function.
BINOMDISTThe individual term binomial distribution probability.
CHIDISTThe one tailed probability of the chi-squared distribution.
CHIINVThe inverse of the one tailed probability (function above).
CHITESTThe value from the chi-squared distribution.
CONFIDENCEThe confidence interval for a population mean.
CORRELThe correlation coefficient between two data sets.
COUNTThe number of numeric values in a list or array of numbers.
COUNTAThe number of non blank cells in a list or cell range.
COUNTBLANKThe number of blank cells in a list or cell range.
COUNTIFThe number of non blank cells that satisfies a condition.
COVARThe average of the products of deviations for each data point pair.
CRITBINOMThe number where the binomial distribution is greater than a criterion value.
DEVSQThe sum of squares of deviations of data points from their sample mean.
EXPONDISTThe exponential distribution.
FDISTThe F probability distribution.
FINVThe inverse of the F probability distribution.
FISHERThe Fisher transformation.
FISHERINVThe inverse of the Fisher transformation.
FORECASTThe future value along a linear trend by using existing values.
FREQUENCYThe number of times a value occurs in a given array or cell range.
FTESTThe result of an F-test.
GAMMADISTThe gamma distribution.
GAMMAINVThe inverse of the gamma distribution.
GAMMALNThe natural logarithm of the gamma function.
GEOMEANThe geometric mean of an array of numbers.
GROWTHThe predicted exponential growth using existing data.
HARMEANThe harmonic mean of a data set.
HYPGEOMDISTThe hyper geometric distribution for a finite population.
INTERCEPTThe intersection with the y-axis using a linear regression plotted through known values.
KURTThe kurtosis of a data set.
LARGEThe Kth largest value in an array of numbers.
LINESTThe array of values for a straight line that best fits your data.
LOGESTThe array of values for an exponential curve that best fits your data.
LOGINVThe inverse of the lognormal cumulative distribution function.
LOGNORMDISTThe cumulative lognormal distribution of x.
MAXThe largest value in a list or array of numbers.
MAXAThe largest value in a list or array of numbers, including text and logical values.
MEDIANThe median of the numbers in a list or cell range.
MINThe smallest value in a list or array of numbers.
MINAThe smallest value in a list or array of numbers, including text and logical values.
MODEThe number that occurs most frequently in a range.
NEGBINOMDISTThe negative binomial distribution.
NORMDISTThe normal cumulative distribution function or probability mass function.
NORMINVThe inverse of the normal cumulative distribution for the specified probability.
NORMSDISTThe standard normal cumulative distribution function.
NORMSINVThe inverse of the standard normal cumulative distribution.
PEARSONThe Pearson product moment correlation coefficient.
PERCENTILEThe Kth percentile of values in an array of numbers.
PERCENTRANKThe percentage rank of a value in an array of numbers.
PERMUTThe number of permutations from a given number.
POISSONThe Poisson distribution.
PROBThe probability that values in a range are between two limits.
QUARTILEThe quartile of a data set.
RANKThe rank of a value in a range (in descending order).
RSQThe square of Pearson product moment correlation coefficient through data points in known Ys and known Xs.
SKEWThe number representing the skewness of a distribution.
SLOPEThe slope of a linear regression line through the given data points.
SMALLThe Kth smallest value in an array of numbers.
STANDARDIZEThe normalized value from a distributed characterised by a mean and a standard deviation.
STDEVThe standard deviation based on a sample.
STDEVAThe standard deviation based on a sample.
STDEVPThe standard deviation based on an entire population.
STDEVPAThe standard deviation based on an entire population.
STEYXThe standard error of the predicted y-value for each x regression.
TDISTThe percentage points probability for the Students t-distribution.
TINVThe t-value of the Students distribution as a function of the probability and the degrees of freedom.
TRENDThe y-values along a linear trend given a set of x-values.
TRIMMEANThe mean of the interior of a data set.
TTESTThe probability associated with a student's t-Test.
VARThe compound variance based on a sample.
VARAThe compound variance based on a sample.
VARPThe variance based on an entire population.
VARPAThe variance based on an entire population.
WEIBULLThe Weibull distribution.
ZTESTThe two-tailed P-value of a z-test.
 

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top