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 |