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: 65402

License: Freeware

More Software Like NumXL

Excel Find and Replace In Multiple

Replace cell text in one or many MS Excel files. Excel 2000 or higher required.
Downloads: 116614 - Shareware - Download Now

Excel Protect&Unprotect Multiple Sh

Protect or unprotect one or many files in MS Excel files. Excel 2000 or higher required.
Downloads: 76298 - Shareware - Download Now

Excel Import Multiple CSV Files Sof

Import many CSV files into one Excel file quickly. Load a list of CSV files into the program and the data will be inserted into a blank workbook.
Downloads: 90761 - Shareware - Download Now

Excel Import Multiple HTML Files So

Convert web site files to Excel. Simply browse to the HTML files and send the contents to a blank Excel workbook. You must have Excel installed on your machine.
Downloads: 107247 - Shareware - Download Now


SQL*XL: Integrating external databases into Excel
Downloads: 104043 - Demo - Download Now