The last step is the application of the model on the whole population. In our case, we note that the parameter of “General Program” does not differ significantly from 0 (at a 5% level). To evaluate if a variable bring significant information, a statistical test is displayed. The following table gives the estimated value of the coefficients for the fitted model. In this case, as the probability is lower than 0.0001, we can conclude that significant information is brought by the variables. This is equivalent to the Fisher's F test: we try to evaluate if the variables bring significant information by comparing the model as it is defined with a simpler model with only one constant. The most important value to look at is the probability of Chi-square test on the log ratio. These results are equivalent to the R2 and to the analysis of variance table in linear regression and ANOVA. The next table gives several indicators of the quality of the model (or goodness of fit). The first results displayed are the statistics for each variable, the dependent variable is represented in blue. The results will then be displayed in a new sheet. The computations begin once you have clicked on OK. Here we choose to leave all the options to their default values. It is also possible to add interactions between the variables. In the Options tab**,** several criteria about the algorithm can be modified. The first column is the response variable and the two others are the explanatory variables. The data are presented in 200 rows and 3 columns table. Once you've clicked on the button, the dialog box appears. Setting up a Log-linear regressionĪfter opening XLSTAT, select the **XLSTAT / Modeling data / Log-linear regression command, or click on the corresponding button of the Modeling data toolbar. Since we have count data, a log-linear regression with a Poisson distribution should be used to explain and/or predict the number of awards earned by a student. To explain the number of awards earned, there are two predictors: the type of program in which the student was enrolled (e.g., vocational, general or academic) and the score on their final exam in math. The data correspond to the number of awards earned by students at one high school. Dataset for log-linear regression (Poisson regression)
#Log transformation xlstat series#
Not sure this is the modeling feature you are looking for? Check out this guide. First, we have to transform the series extracted from the database of the Bank of England to obtain their log values. This tutorial will help you set up and interpret a Log-Linear regression, also called Poisson regression in Excel using the XLSTAT software.
0 kommentar(er)
