## Products news & updates

### Announcements

- ★ NumXL SDK is here
- ★ NumXL 1.63 is here
- ★ License Agreement Updates
- NumXL 1.62 DEWDROP is here
- NumXL 1.61 BOLAS is here
- NumXL 1.60 APACHE is released

### Release notes

- ★ NumXL 1.63 (Shamrock)
- NumXL 1.62 (Dewdrop)
- NumXL 1.61 (Bolas)
- NumXL 1.60 (Apache)
- NumXL 1.59 (Tucson)
- NumXL 1.58 (BAJA)

### Tips & Demos

### Surveys

## Tutorial Videos

### Overviews

### Data Preparation

### Descriptive Statistics

### Statistical Testing

- ★ Johansen Test for Cointegration
- Regression stability test in Excel
- Multi-collinearity test in Excel
- Statistical Testing in Excel
- ARCH Effect Test in Excel
- Stationary Test in Excel

### Smoothing

### Date & Calendar

### ARMA Analysis

- SARIMAX Modeling, Forecast & Simulation Demo
- SARIMA Modeling & Forecast Demo
- ARIMA Modeling and Forecast Demo
- ARMA Modeling and Forecast in Excel
- ARMA calibration in Excel
- ARMA forecast in Excel

### GARCH Analysis

### Factor Analysis

- PCA tutorial in Excel - Part 2
- Regression stability Test (Chow Test) in Excel
- Influential Data Regression Analysis in Excel
- Step-wise regression tutorial in Excel - Part 2
- Regression Analysis in Excel - 101
- Tutorial: Principal component analysis 101 in Excel

### Spectral Analysis

### Power Tools

### Misc.

## FAQ

### Modeling

### SDK

- Where can I get more information? How do I start?
- I have a technical issue/question with NumXL SDK, who do I contact?
- Can I use NumXL and my custom application at the same time?
- I anticipate many deployment for my custom application, can I get an additional discount on NumXL Licenses?
- How much does it cost to deploy a custom application?
- How much does NumXL SDK cost?

### Support

### Sales

- Do you have a VAT or DUNS Number?
- My company/organization would like several licenses, do you offer site licenses?
- I'm an instructor, how can I use NumXL for my classroom?
- After I purchase a license, do I need to reinstall the software?
- Why are you applying VAT to my order?
- How does the coupon/voucher discount system work?

### Online Store

### Functions

- GARCH_CHECK returns true even when the sum of alpha and beta equals to one?
- Where is X-12-ARIMA?
- Can I compute the logarithmic return from a time series without any intermediate calculations?
- How can I compute the expiry date of an equity option?
- How can I use NumXL to compute the correlation matrix for 2 time series?
- How do I test whether a given time series is just noise?

### Microsoft Excel

- ★ Which versions of Excel are compatible with your Add-ins?
- Where do I find Excel Add-ins Manager?
- Is NumXL compatible with non english excel versions?
- My Excel installation is outdated, what does this mean?
- The cells in my output show #NAME?, what am I doing wrong?
- Locking Excel References

### Licensing

- Do I get full fuctionality of NumXL in the 14 day trial?
- I bought a perpetual license last year, but do I have to renew my Premier Support?
- License Manager reports an error for my 5th machine?
- Where do I find NumXL License Manager?
- I forgot my license key, how can I retrieve it?
- How do I deactivate/unlock my license?

### Installation

- Can I use NumXL on my Mac?
- I installed NumXL for everyone, what is next?
- Install NumXL on CITRIX Server
- Installer integrity check failed?
- The installer doesn't start. Instead, Windows says the file is corrupted.
- Can I use your product on a Virtual Machine (VM)?

### General

- ★ Where can I write a customer's review?
- How can I submit feedback or file a defect or claim?
- What do I need to know to use NumXL?
- How often does Spider Financial release new versions of NumXL?
- What are the system requirements for installing NumXL?
- Do you offer live demos/Can I request a live demo?

## Documentation

### Installation Guide

### Examples

- Descriptive Statistics
- Statistical Tests
- Transform
- Smoothing
- ARMA & ARIMA Analysis
- ARCH/GARCH Analysis

### NumXL SDK Getting Started Guide

- Using NumXL SDK API in NET
- NumXL SDK Components
- Installing NumXL SDK
- NumXL SDK Licensing
- Checking deployment environment
- Using NumXL SDK API in C/C++

### Technical Notes

### Misc.

## Reference Manual

### Factor Analysis

- PCR_FITTED - PCR In-Sample Fitting
- PCR_FORE - PCR Forecast
- PCR_GOF - PCR Goodness-of-fit
- PCR_PARAM - PCR Coefficients
- PCR_PRFTest - Partial F-test for PCR
- PCR_STEPWISE - Stepwise Principal Components Regression

### ARMA Analysis

- SARIMA - SARIMA Model Definition
- SARIMA_CHECK - SARIMA Model Validation
- SARIMA_FIT - SARIMA In-Sample Fitting
- SARIMA_FORE - SARIMA Forecast Function
- SARIMA_GOF - SARIMA Goodness-of-fit
- SARIMA_PARAM - SARIMA Model Parameters

### Spectral Analysis

### Smoothing

### Transform

- PROBIT - Probit Transform
- RESAMPLE - Time Series Resampling
- REVERSE - Reverse Chronicle Order
- RMNA - Remove Missing Values
- SUBNA - Interpolate Missing Values
- SUBSET - Time Series Subset

### Statistical Testing

- TEST_MEAN - Population Mean Test
- TEST_SKEW - Skewness Test
- TEST_STDEV - Standard Deviation Test
- TEST_XKURT - Excess Kurtosis Test
- WNTest - White-Noise Test
- ADFTest - Augmented Dickey-Fuller Stationary Test

### Descriptive Statistics

- Quantile - Sample Quantile
- MD - Mean Difference
- RMD - Relative Mean Difference
- RMS - Root Mean Square
- RMSD - Root Mean Squared Deviations
- RMSE - Root Mean Squared Error