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.
Replace cell text in one or many MS Excel files. Excel 2000 or higher required.
Downloads: 116614 - Shareware - Download Now
Protect or unprotect one or many files in MS Excel files. Excel 2000 or higher required.
Downloads: 76298 - Shareware - Download Now
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
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