NumXL 1.63 (Shamrock)

NumXL 1.63 offers various simple tools for conducting complicated statistical analysis in Microsoft Excel. The new version supports ARIMA, SARIMA, ARMAX, monte carlo and time series simulation.

Scene 1:

Hello and welcome to the Introduction video to NumXL 1.63.

Once you’ve installed NumXL 1.63, the software adds a separate tab in Microsoft Excel with loads of shortcuts to common and advanced functionality that will make your modeling and forecast tasks a lot easier.

(Add shadow Box) NumXL operates on your sample data both in the time domain

Scene: Frequency-domain

And in the Frequency domain

Scene 4,6:

Here are few functions you can find in the NumXL 1.63 Descriptive Statistics tab

Scene 7:

Various Statistical Tests

Scene 9:

Several Linear Time series models.

Scene 10:

You can also access our functions through the excel functions toolbar.

NumXL offers hundreds of worksheet functions for your use.

Scene: help file

Each function is backed up with full documentation in the help file that comes with NumXL software.

Scene: support-portal

You can also visit support.numxl.com to access our online help desk.

Scene: tutorial-videos

The site offers a lot of tutorials and tips of how to make the most of NumXL

Scene: FAQ

There is also an extensive frequently asked questions section where you can find an answer to virtually any question you may have.

If you still have question, issue or concern, you can always contact us via email or by phone.

Scene: summary statistics

Now, let’s take a look at some of the things you may expect from NumXL.

NumXL gives you numerous tools to compute summary statistics for your data set, and visualize empirical distribution.

This will gives you a lot of information about your particular data.

Scene: QQ-Pot

Plotting a QQ-Plot can’t be simpler with NumXL Wizard.

Scene: White-noise Test

Want to find out if your sample data is plain noise (aka uncorrelated).

No problem, NumXL provides a series of statistical tests to answer this question and others about your data.

Scene: statistical-test-relevance

We picked the statistical tests that are most relevant to your analysis.

Scene: Correlogram

Examining the serial dependencies in your sample data can be examined within seconds using NumXL Correlogram Wizard.

Scene: ARMA-Analysis

NumXL Also support a wide range of linear time series models including ARMA, ARIMA, SARIMA, AirLineand US census X12ARIMA methodology.

Scene: ARMAX

Starting with version 1.63, NumXL supportsARMAX and SARIMAX (aka regARIMA) for capturing regression models with correlated residuals.

Scene: AirLine example

Each model comes with a simple Wizard that guide you through the whole process, and generate different calculations and formulas into your worksheet in Excel.

Scene: X12 ARIMA

In just few clicks, you can use the US census supported program X12 ARIMA.

This tool empower you to conduct sophisticated modeling and analytics such as X11 seasonal adjustment.

NumXL does all the hard work behind the scene, so you don’t have to worry about anything.

Scene: GARCH

When performing volatility modeling, you can use GARCH, exponential GARCH and GARCH in the mean models to capture volatility dynamics in financial time series and other data.

Scene: Simulation-wizard

Starting with version 1.63, NumXL fully support the time series and Monte-Carlo simulations through an easy-to-follow wizards and several worksheet functions.

Scene: Simulation-output

With this new functionality, you may conduct scenarios and/or all sort of ad-hoc analysis right in your worksheet.

Scene: MLR

In addition to ARMAX, NumXL support factor analysis with linear regression modeling.

With this tool, we fill a huge gap left by Excel’s version of regression.

Now, you can experiment with various models, examine residuals for model, and overcome many problem faced by professionals during regression projects

.Scene: Stepwise

Your arsenal of NumXL Tools also include stepwise regression that can help you find the optimal set of input variables in your model.

Scene: Cook

One advanced diagnostic tool that NumXL Offer is influential data analysis that uses both leverage statistics and Cook’s distance.

With those two powerful tools, we are in better position to to identify data points that makes our analysis biased.

Scene: PCA

The principal component analysis (akaPCA) is also available in 1.6X version of NumXL.

With PCA you can linearly transform a set of correlated data into uncorrelated factors, and using a subset of the uncorrelated factors, you can transform them into the original data set space.

Scene: Smoothing

All NumXL Functions are accessible through your worksheet, and many of them don’t have their own wizard yet.

For instance, numxl support a wide range of time series smoothing functions such as WMA, simple, double, linear and triple exponential smoothing and trend functions.

Scene: DFT

In the spectral analysis section, NumXL provide discrete Fourier transform and its inverse, for any time series size/length.

Scene: Interpolate

Another example is the interpolation and extrapolation function.

NumXL supports four methods for interpolations: Forward flat, backward flat, linear and cubic spline

The NumXL team works hard to constantly update the software and provide you with different functions that you’d need during your data analysis.

We encourage you to take advantage of NumXL tools, and don’t hesitate to call our customer support service with any idea or concern.

Scene: goodbye

That is it for now, thank you for watching.

Have more questions? Submit a request

0 Comments