Generalized Linear Models Regression Model Viewer

This selection displays a successfully built Linear Regression model, that is, a Generalized Linear Models (GLM) regression model, and its characteristics.

For a brief description of the Generalized Linear Models (GLM) algorithm, see Generalized Linear Models Algorithm.

Oracle Data Mining 11g uses GLM to solve two different kinds of problems: classification and regression. The resulting models have different viewers.

For a brief description of regression models, see Regression Models.

Menus

The following menus appear when the model is displayed in a new window:

Tabs

The model viewer has the following tabs:

Global Statistics

The Target Attribute for the model is displayed; this is the target selected when defining the Build Activity.

GLM regression models generate the following statistics that describe the model as a whole: model degrees of freedom, model sum of squares, model mean square, model F statistic, model F value probability, error degrees of freedom, error sum of squares, error mean square, corrected total degrees of freedom, corrected total sum of squares, root mean square error, dependent mean, coefficient of variation, R-Square, Adjusted R-Square, Akaike's information criterion, Schwarz's Baysian information criterion, estimated mean square error of the prediction, Hocking Sp statistic, JP statistic (the final prediction error), number of parameters (the number of coefficients, including the intercept), number of rows, whether or not the model converged (yes or no), and whether or not a covariance matrix was computed (yes or no).

The following information is displayed for each metric:

To save the metrics as a text file or a spreadsheet, click the Save As icon (a yellow arrow above a graphic of a page) above the grid that lists the metrics.

Coefficients

This tab lists the coefficient value for specific target value and attribute value pairs. Coefficients represent model details.

The Target Attribute for the model is displayed; this is the target selected when defining the Build Activity.

The default Fetch Size for coefficients is 100; you can change the fetch size. To fetch the next set of coefficients, click Refresh.

To filter results, click Filter.

The coefficients are displayed in the Coefficients grid. If you want coefficients sorted by absolute value so that, for example, -0.5 is listed just before +0.5, click the Sort coefficients based on absolute value checkbox at the bottom of the window.

The following information is displayed:

To save the coefficients information as a text file or a spreadsheet, click the Save As icon (a yellow arrow above a graphic of a page) above the Coefficients grid.

Diagnostics

To see the Diagnostics tab, you must select Generate Diagnostics Table in the Build settings for the model. The default is to not generate a diagnostics table; if a diagnostics table is not generated, the Diagnostics tab is not displayed.

The following diagnostics are generated for linear regression:

The diagnostics are displayed in a grid. The following control the display of diagnostics:

The following information is displayed in the grid:

To save the diagnostics as a text file or a spreadsheet, click the Save As icon (a yellow arrow above a graphic of a page) above the grid.

Results

The tab contains a tree view of test metrics, apply results, and residual plot. To view specific results, select the result, and click View. To delete a result, select one or more results and click Delete.

Build Settings

This tab displays the settings used to build the Support Vector Machine (SVM) regression model.

The Type of the model (Regression), the Algorithm (Generalized Linear Models), and the Target Attribute are displayed. Oracle Data Mining 11g models can be built using Automatic Data Preparation (ADP). If the model was built using ADP, then Automatic Data Preparation has the value yes.

The following algorithm settings are displayed:

For detailed information about the settings, see GLM Regression Settings.

The attributes used to build the model are displayed in the Attributes grid; the following information is displayed for each attribute:

To save the attributes information as a text file, click the Save As icon (a yellow arrow above a graphic of a page) above the Attributes grid.

Task

This tab describes the task used to build the model. It shows when the task ran, what input was used, and what output was created.