GLM Example 3: Gaussian Distribution Analysis with Default Options - Teradata Vantage

For the Gaussian distribution the response variable must be a continuous numerical variable, where the data is grouped around a single mean and the graph looks like a normal or bell curve distribution.

Input

The input table, housing_train, is real estate data on homes, which models the home price with 12 predictors (six numerical and six categorical variables).

SQL Call

In this example, the family is GAUSSIAN and the default family link is IDENTITY.

DROP TABLE glm_housing_model;

SELECT * FROM GLM (
  ON housing_train AS InputTable
  OUT TABLE OutputTable (glm_housing_model)
  USING
  InputColumns ('price', 'lotsize', 'bedrooms', 'bathrms',
                'stories', 'garagepl', 'driveway', 'recroom',
                'fullbase', 'gashw', 'airco', 'prefarea', 'homestyle')
  CategoricalColumns ('driveway', 'recroom', 'fullbase', 'gashw',
                       'airco', 'prefarea', 'homestyle')
  Family ('GAUSSIAN')
  LinkFunction ('IDENTITY')
  WeightColumn ('1')
  StopThreshold (0.01)
  MaxIterNum (25)
  Step ('false')
  Intercept ('true')
) AS dt;

Output

Many predictors are significant at 95% confidence level (p-value < 0.05).

This query returns the following table:

SELECT * FROM glm_housing_model ORDER BY attribute;