Generalized Linear Models (GLM)

The generalized linear model (GLM) is a flexible generalization of ordinary linear regression.

By allowing the linear model to be related to the response variable via a link function, GLM generalizes linear regression. It also allows the magnitude of the variance of each measurement to be a function of its' predicted value.


Select an empty cell to store the output GLM model table, locate the GLM icon in the NumXL tab, and click on it.
In this figure, we show the GLM icon in the NumXL toolbar.

The GLM model wizard (form) pops up. Now, point to the data sample on your worksheet, select the link function, the goodness of fit tests, residual diagnosis, and designate a location on your worksheet to print the model.
In this figure, we show the GLM Model Dialog / Wizard.


Upon completion, the GLM modeling function prints the selected model's parameters and tests/calculations in the designated location of your worksheet.
In this figure, we show the GLM output table as generated by NumXL functions and Wizards.

Tutorial Video


Article is closed for comments.

Was this article helpful?
1 out of 6 found this helpful