Published on Oct 16, 2012
In this video, we give a quick overview of NumXL 1.58 (BAJA) in Excel. This updated version comes with a number of new features that can assist statistical analysis in Excel.
Hello and welcome to an overview of NumXL 1.58. This updated version comes with a number of new features that can assist statistical analysis in Excel. First we've added the histogram and QQ plot wizards.
This easy-to-use wizard helps you create a histogram in your worksheet. Simply select your input data, you can choose a rule to estimate the optimal number of bins. Note that the number of bins is recalculated each time you change the rule. You can also choose to overlay a Gaussian distribution in the same plot for easy referencing.
This is how our result of this function looks like. The wizard stores formulas and the output table cells, so you can always change the input data on the spot.
The QQ plot wizard allows you to pick the number of quantiles for your analysis.
Its output table is also dynamic, you can make changes by adding new rows and copying the formula down.
You can also find four new Wizards under the statistical testing in the toolbar.
In the normality test wizard you can select your sample data, choose which tests to include, and what to do with intermediate missing values,
and just like that you have the result of the test.
With the white noise test wizard you can select your input data, choose the lag order range to test for, and what to do with intermediate missing values if they are present.
Just like in the white noise test wizard, the arch test lets you select your input data, choose lag order range, and it also lets you pick what to do with the missing values.
And in the stationary test wizard, select the sample data, choose the unit root test such as the augment dickey-fuller test, and its conditions, and pick what to do if the sample has intermediate missing values.
The wizard generates test results in an intuitive output table for each ADF test scenario.
That is it for now, thank you for watching!