En este video, demostramos cómo crear una gráfica QQ en Microsoft Excel con la ayuda del nuevo NumXL 1.58 (BAJA) recientemente lanzado. 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 QQ plot tutorial. In this video we'll demonstrate how to create a histogram with the help of a simple user interface available with version 1.58 of NumXL. For this example we'll be using the daily log returns of the S&P 500. First select an empty cell in your worksheet then click on the description statistics button in the NumXL toolbar. Click on the QQ plot 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.
Scene 3:
Once you select your data you can pick the number of quantiles or the number of points for your QQ plot. Next, click OK.
Scene 4:
And voila, the QQ plot is in your worksheet. the output table is dynamic. You can make changes by adding new rows and copying the formula down.
Scene 5:
That is it for now, thank you for watching!
Comentarios
Inicie sesión para dejar un comentario.