What’s New in NumXL 2.0
Although, NumXL 2.0 is not officially out, this article will give you a good head start on the new features in NumXL 2.0.
- Summary Statistics (support for missing observations)
- Data Transformation (support for missing observations)
- smoothing function (e.g.
moving average, exponential, kernel Gaussian smoothing, etc.) - LAGi, DIFF, fractional difference, Add, Sub, Scale
- Transformation (BoxCox Optimal Transform)
- Filter: Low-Pass High-Pass, Band-Pass, Band-Stop, and ARMA Filter
- Fourier transform, Wavelet transform
- smoothing function (e.g.
- Statistical Distributions
- Histogram
- Normal, Student’s t, Chi-square, Fischer-Snedecor (F-dist), Gamma, Poisson, Weibull, Exponential, Beta, Laplace, power exponential (GEDi) and Log Normal distributions
- PDF, CDF, InvCDF
- P-Value and Critical Value
- MAD, SD, Skew and Kurtosis
- Fourier transform,
Wavelet transform
- Parametric Modeling
- Model Functions
- Statistical tests (support for missing observations)
- Covariance Analysis
- Covariance matrix, exponential-weighted covariance matrix
- Covariance to Correlation matrix transform
- Matrix positive-definite test
Furthermore, the functionality offered through the menus, tool-bars and form wizards has been revised to enhance the usability of both the existing and new functions.