Prueba de Estabilidad de la Regresión con Excel

Este video muestra cómo hacer una prueba Chow para estabilidad de regresión con NumXL 1.60 en Microsoft Excel.

Guion de Video

Scene 1:

Hello and welcome to NumXL 1.6 tutorial. In this video I'll demonstrate how to do a CHOW test for a regression stability. I'll use a sample data gathered from 20 different salespeople.

This regression model will attempt to explain and predict a person's weekly sales which is a dependent variable. This will be done using two explanatory variables, intelligence, IQ and extraversion.

First select a cell in your worksheet where you want the analysis output to be located. Next, find the statistical test icon in the NumXL tab and from the drop down menu click on regression stability test.

Scene 2:

A regression stability test wizard pops up. For each data set select a cells range for the dependent variable Y and explanatory variable X. Let's start with data set one. Then select data for data set two.

Scene 3:

For the intercept or the constant value, if your model forces the intercept to be a fixed value then enter it here, otherwise leave it blank to indicate that it is a parameter calculated from the data set.

Once the data sets are selected the options and missing values tabs become available. Click on the options tab.

Scene 4:

The options tab shows which methods are supported, currently we implement CHOW test. 

Scene 5:

In the missing values tab leave the default selection which removes observations with any missing value in X or Y. Now click OK, to display the test results.

Scene 6:

And there you go, the table shows the test stat score p-value and compares it against a significance level. In this example the regression model seems to be stable over the sample data.

Scene 7:

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 1