En este video demostramos cómo conducir una prueba de Efecto ARCH en Microsoft Excel con la ayuda de la nueva versión de NumXL - 1.58 BAJA lanzada recientemente.
NumXL es una adición para Excel que simplifica enormemente los diferentes cálculos usados en el análisis de series de tiempo.
Scene 1:
Hello and welcome to the NumXL ARCH effects test tutorial. In this video will demonstrate how to run an ARCH effect test with the help of a simple user interface available with the version 1.58 of NumXL. We'll be using the daily log returns of the S&P 500 for this example.
The first step is to select an empty cell in your worksheet then click on the statistical testing button in the NumXL toolbar.
Click on the ARCH effect test icon, a function wizard pops up as soon as you do that.
Scene 2:
For input data select your sample values. You may choose a significance level for the test, but the default is five percent. Now the output defaults to your selected cell in the worksheet.
Once you select data the options and the missing values tabs become clickable.
Scene 3:
In the options tab you may pick what kind of lag order range to test for.
Scene 4:
And you can also choose what to do with intermediate missing values in your data in the last tab.
Scene 5:
You may now click OK, and there you go the arch effect tests results are in your worksheet.
Scene 6:
That is it for now, thank you for watching!
Comentarios
Inicie sesión para dejar un comentario.