NumXL Description

NumXL Functions implement quantitative statistical and econometric functions for applications to capital markets.Key features of the NumXL Functions for Excel include:* Descriptive statistics - Function for sample mean, standard deviation, skewness, excess kurtosis, and correlation.* Statistical tests 1- Function for testing the mean, standard deviation, skewness and excess kurtosis.* Statistical tests 2: Functions for testing the normality (e.g. Jarque-Bera, Wilk-shapiro) and serial-correlation/white-noise (Ljung-Box).* Linear time series - Function for autocorrelation, partial-autocorrelation, lag or backshift operator, difference operator.* WMA and EWV(EWMA) - Functions for weighted moving average (WMA), exponential weighted volatility (EWV) and exponential weighted moving average (EWMA).* ARMA/ARIMA - Function for autoregressive moving average model (ARMA)* Linear time series - ARMA conditional mean forecast and confidence interval estimate, ARMA residuals inspection* ARCH - ARCH/GARCH/EGARCH/GARCH-M based Functions; ARCH effect test, likelihood functions, Akaike\'s information criterion (AIC), stability test, conditional volatility and mean forecast, confidence interval limits.* GED/t-dist - Support for fat-tailed innovations: Generalized error distribution (GED), Student t-distribution* Interpolation - forward-flat, backward-flat, linear and cubic spline (cspline) interpolation and extrapolation.



Publisher: | Download

Category: Business > Spreadsheets

Size: 2.15MB

OS: Win 95/98/Me/NT/2000/XP/Vista

Downloads: 72417

License: Freeware

More Software Like NumXL

Formula Navigator

Formula Navigator is a clever tool for understanding the linkages within a complex spreadsheet. It is both a spreadsheet productivity enhancer and spreadsheet review tool, useful for anyone working with large and complex Microsoft Excel spreadsheets.
Downloads: 97126 - Shareware - Download Now

Consolidate Worksheets Wizard for Excel

With Ablebits.com Consolidate Worksheets Wizard you can easily combine multiple worksheets into one or merge several workbooks and csv files without opening them.
Downloads: 89994 - Shareware - Download Now

DoneEx XCell Compiler

Excel workbook copy protection tool, compiles XLS to EXE application (which requires MS Excel to run) with securely hidden formulas and VBA code. Copy protection with regkey; create trial ver of workbook; See details at www.DoneEx.com
Downloads: 102017 - Shareware - Download Now