Normality Testing in Excel

In this video, we demonstrate how to conduct a Normality Test in Microsoft Excel with the help of a newly released version of NumXL - 1.58 BAJA. NumXL is an add-in for Excel that greatly simplifies different calculations used in time series analysis.

Video script

Scene 1:

Hello and welcome to the NumXL normality test tutorial. In this video will demonstrate how to create a normality test with the help of a simple user interface available with the version 1.58 of NumXL. We'll be using daily log returns of the S&P 500 for this example.

First select an empty cell in your worksheet, then click on the statistical testing button in the NumXL toolbar. Click on the normality test icon.

Scene 2:

A function wizard pops up. For input data select your sample values, remember the output defaults to the selected cell in your worksheet. Once you select your input data you can pick more options.

Scene 3:

In the options tab there are three tests you can choose to include, Jarque Bera, Shapiro Wilk, and Doornik Chi-square tests. For now we'll select all of them which is the default.

In the missing values tab you can decide what to do with intermediate values that are missing in the data. You may choose to remove them or estimate a mean or median value. Removing the missing value is the default and we'll leave it checked for our purposes.

Scene 4:

Back in the general tab, you can also choose a different significance level, the default is five percent. You may now click OK.

Scene 5:

And there you go, your normality test results are in your worksheet. It's that easy!

Scene 6:

That is it for now, thank you for watching!



Please sign in to leave a comment.

Was this article helpful?
1 out of 2 found this helpful