4/25/2023 0 Comments Regression for excel mac![]() ![]() ![]() We see that the model starts out with no variables (range G6:J6) and terminates with a model containing x 1 and x 4 (range G12:J12). Lets call this variable z m 1 and suppose the p-value for the z m 1 coefficient in the regression of y on z 1, z 2, z m, z m 1 is p.Īn empty cell corresponds to the corresponding variable not being part of the regression model at that stage, while a non-blank value indicates that the variable is part of the model. Whereas for most statistical tests a value of alpha.05 is chosen, here it is more common to choose a higher value such as alpha.15 or.20.Ĭhoose the independent variable whose regression coefficient has the smallest p-value in the t test that determines whether that coefficient is significantly different from zero.Īs in step 2a, choose the independent variable whose regression coefficient has the smallest p-value.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |