The SDL Component Suite is an industry leading collection of components supporting scientific and engineering computing. Please visit the SDL Web site for more information....



Comparison to Excel Functions


The following table lists all routines of Microsofts Excel® having a corresponding routine in the SDL component suite. Please note that the Excel functions refer to the English version of Excel, the function names differ in other languages. Further, the results of Excel sometimes differ from the results of the SDL Suite. This is not a bug in the SDL Suite (we have checked the results against SPSS, one of the world's leading statistics packages) but is mostly due to different definitions used by Excel (especially as far as small samples are concerned).

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


Last Update: 2012-Okt-20