Prueba de Dickey-Fuller Aumentada (DFA) en Excel

En este video, demostraremos cómo llevar a cabo una prueba estacionaria en un conjunto de datos en Microsoft Excel con la ayuda del nuevo lanzamiento NumXL 1.58 (BAJA). NumXL es un agregado de Excel que simplifica ampliamente diferentes cálculos usados en el análisis de series de tiempo.

Guion de Video

Scene 1:

Hello and welcome to the NunmXL stationery test tutorial. In this video will demonstrate how to run a stationery test with the help of a simple user interface available with the version 1.58 of NumXL. We'll use 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 stationery test icon.

Scene 2:

A function wizard pops up, for input data select your sample values. The output defaults to the selected cell in your worksheet. You may also choose a significance level for the test, the default is 5%. Once you select your data you can click on the options and the missing values tabs.

Scene 3:

Now you may choose the unit root test such as the augment dickey-fuller test and its conditions. You can also choose a lag order range to test for. In the missing values tab you can pick what to do if the input sample has intermediate missing values. The default is to not accept missing values which we'll leave checked.

Scene 4:

You may now click OK, and there you go the stationery tests results are now in your worksheet.

Scene 5:

That is it for now, thank you for watching!

 

Comentarios

Inicie sesión para dejar un comentario.

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