Excel routine 
SDL routine 
Remarks 
AVERAGE 
CalcStatistics,MeanX, MeanY, MeanVar 
Returns the average of its arguments. The SDL component suite contains several methods to calculate means (classes TCurveFit, TVector, and TMatrix). 
BETADIST 
IncompleteBeta 
Returns the cumulative beta probability density function. 
CHIDIST(x,df) 
1  Chi2DistriIntegral (x,df) 
Returns the onetailed probability of the chisquared distribution. Please note the slightly different approach concerning the definition of the probability between Excel and the SDL routines  see Chi2DistriIntegral for more details.

CHIINV(p,df) 
Chi2DistriQuantile (1p,df) 
Returns the inverse of the onetailed probability of the chisquared distribution. Please note the slightly different approach concerning the definition of the probability between Excel and the SDL routines  see Chi2DistriQuantile for more details. 
CONFIDENCE 
ConfidenceInterval 
Returns the confidence interval for a population mean 
CORREL 
CorrCoeff, CalcCovar 
Returns the correlation coefficient between two data sets 
COVAR 
CalcCovar 
Returns covariance, the average of the products of paired deviations 
ERF(x) 
Erf (x) 
Returns the error function integrated between zero and x. 
ERFC(x) 
1Erf (x) 
Returns the complementary error function integrated between x and infinity. 
FDIST(x,df1,df2) 
1  FDistriIntegral (x,df1,df2) 
Returns the F probability distribution. Please note the slightly different approach concerning the definition of the probability between Excel and the SDL routines  see FDistriIntegral for more details. 
FINV(p,df1,df2) 
FDistriQuantile (1p,df1,df2) 
Returns the inverse of the F probability distribution. Please note the slightly different approach concerning the definition of the probability between Excel and the SDL routines  see FDistriQuantile for more details. 
FISHER 
FischerTransform 
Returns the Fisher transformation 
FISHERINV 
FischerTransformInv 
Returns the inverse of the Fisher transformation 
GAMMALN(x) 
lnGamma (x) 
Returns the natural logarithm of the gamma function, G(x) 
GEOMEAN 
GeometricMean 
Returns the geometric mean. The method GeometricMean is available for the classes TVector and TMatrix. 
HARMEAN 
HarmonicMean 
Returns the harmonic mean. The method HarmonicMean is available for the classes TVector and TMatrix. 
HYPERGEOM 
HyperGeoDistriDensity 
Calculates the propability density function of the hypergeometric distribution 
INTERCEPT 
CalcLinFit 
Returns the intercept of the linear regression line 
KURT 
SkewKurt, SkewKurtSample 
Returns the kurtosis of a data set. Both the class TVector and TMatrix offer the method SkewKurt and SkewKurtSample. Please note that the Excel function KURT corresponds to the routine SkewKurtSample. 
MAX 
MinMax 
Returns the maximum value in a list of arguments. The method MinMax is available for the classes TVector and TMatrix. 
MEDIAN 
Quartiles 
Returns the median of the given numbers. The method Quartiles is available for the classes TVector and TMatrix. 
MIN 
MinMax 
Returns the minimum value in a list of arguments. The method MinMax is available for the classes TVector and TMatrix. 
NORMDIST (x,m,s) 
nDistriIntegral ((xm)/s) 
Returns the normal cumulative distribution 
NORMINV(p,m,s) 
m + s*nDistriQuantile (p) 
Returns the inverse of the normal cumulative distribution 
NORMSDIST 
nDistriIntegral 
Returns the standard normal cumulative distribution

NORMSINV 
nDistriQuantile 
Returns the inverse of the standard normal cumulative distribution 
PEARSON 
CorrCoeff, CalcCovar 
Returns the Pearson product moment correlation coefficient 
PERCENTILE 
Percentile, PercentileOfNumCells 
Returns the percentiles of a data set. The SDL Component Suite contains several methods to calculate percentiles (classes TVector, TMatrix, and TDataTable) 
QUARTILE 
Quartiles 
Returns the quartile of a data set 
RSQ 
sqr(CorrCoeff) 
Returns the square of the Pearson product moment correlation coefficient 
SKEW 
SkewKurt, SkewKurtSample 
Returns the skewness of a distribution. Both the class TVector and TMatrix offer the method SkewKurt and SkewKurtSample. Please note that the Excel function KURT corresponds to the routine SkewKurtSample. 
SLOPE 
CalcLinFit 
Returns the slope of the linear regression line 
STANDARDIZE 
StandardizeRows, StandardizeColumns 
Returns a normalized value 
STDEV 
MeanVar, StdDevX 
Estimates standard deviation based on a sample

STDEVP 
MeanVar 
Calculates standard deviation based on the entire population 
TDIST (x,df) 
1 tDistriIntegral (x, df) 
Returns the Student's tdistribution. Please note the slightly different approach concerning the definition of the probability between Excel and the SDL routines  see tDistriIntegral for more details. 
TINV (p,df) 
tDistriQuantile (1p, df) 
Returns the inverse of the Student's tdistribution. Please note the slightly different approach concerning the definition of the probability between Excel and the SDL routines  see tDistriQuantile for more details. 
TREND 
CalcLinFit 
Returns values along a linear trend 
TTEST (array1,array2,tails,type) 
Perform2SampleTTest (Data1, Data2, TestType, OneSided) 
Performs a 2sample tTest. Please note that the data points are passed to the function as vectors and not as arrays 
VAR 
MeanVar 
Estimates variance based on a sample 
VARP 
MeanVar 
Calculates variance based on the entire population. 
WEIBULL 
WeibullDensity 
Returns the Weibull distribution 