Pruebas de normalidad en Excel

En este video demostramos cómo conducir una prueba de Normalidad en Microsoft Excel con la ayuda de una nueva versión de NumXL - 1.58 BAJA. NumXL es una adición para Excel que simplifica enormemente los distintos cálculos usados en el análisis de series de tiempo. 

Guion de Video

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!



Inicie sesión para dejar un comentario.

¿Fue útil este artículo?
Usuarios a los que les pareció útil: 1 de 2