Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 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).
AVERAGEIFThe arithmetic mean of all the numbers in a range that satisfies a condition.
AVERAGEIFSThe arithmetic mean of all the numbers in a range that satisfy multiple conditions.
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 non blank cells in a list or cell range.
COUNTAThe number of non blank cells in a list or cell range (including text and logical values).
COUNTBLANKThe number of blank cells in a list or cell range.
COUNTIFThe number of non blank cells that satisfies a condition.
COUNTIFSThe number of non blank cells that satisfy multiple conditions.
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 for a list or array of numbers.
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 (including text and logical values).
STDEVPThe standard deviation based on an entire population.
STDEVPAThe standard deviation based on an entire population (including text and logical values).
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 (including text and logical values).
VARPThe variance based on an entire population.
VARPAThe variance based on an entire population (including text and logical values).
WEIBULLThe Weibull distribution.
ZTESTThe two-tailed P-value of a z-test.
 

 Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top