| 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 one-tailed probability of the chi-squared 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 (1-p,df) |
Returns the inverse of the one-tailed probability of the chi-squared 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) |
1-Erf (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 (1-p,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 ((x-m)/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 t-distribution. 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 (1-p, df) |
Returns the inverse of the Student's t-distribution. 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 2-sample t-Test. 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 |
MathPack 
