# Time Series Analysis

## Excel Time Series Analysis for Forecasting and Prediction

 Submit an Excel Solution Submit Solution [Guide]

 Find Excel Solutions:
Select suggested text to load results or icon to view solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity

 Time Series Analysis for Excel (NumXL) is a comprehensive and powerful add-in solution for Excel to provide analysis of time series and econometric data with forecasting options. Time series analysis functions can be called within cell functions or constructed using the intuitive function building wizard interface.Indispensable time series analysis calculations include autocorrelation testing, logarithmic fit analysis, model fitting and calibration, automatic forecasting and diagnosis of residuals. The resulting time series and econometric analysis is presented in a structured report in order to present conclusions and recommendations efficiently and effectively.Key features of Time Series Analysis for Excel include: Descriptive statistics - population mean, variance, skew and excess Kurtosis tests. Normality analysis - Jarque–Bera, Shapiro–Wilk and Chi-square tests. White noise analysis - Portmanteau, Ljung-Box and modified Q tests. ARCH effect analysis. Time series analysis - lag and difference operators, weighted moving Average, exponential weighted moving average, correlation and exponential weighted correlation, autocorrelation and partial autocorrelation analysis. Model fitting analysis - log likelihood, Akaike information criterion, stability checking and residuals analysis. Forecasting and back testing - in sample and out sample forecasts, mean and confidence interval forecasting, conditional and term structure volatility and long run forecasting. Model support - autoregressive moving average (ARMA, ARIMA and ARMAX), AirLine model, generalized lnear model, generalized autoregressive conditional heteroskedacity models (ARCH/GARCH), exponential GARCH and GARCH in the mean

(Pricing is available on the next page)

 Related Excel Solutions: Multiple Regression Forecasting (Forecasting and Prediction) | Statistical Analysis (Risk Analysis) | Time Series Forecasting (Forecasting and Prediction) | Forecasting Add-in (Forecasting and Prediction) | Quantitative Econometric Functions (Technical Analysis) | Statistical Distribution Fitting (Risk Analysis) | Statistics Add-in (Forecasting and Prediction) | Economic Simulations (Risk Analysis)