Linear Regression Example | Teradata Vantage - Linear Regression Example - Teradata Vantage

This example uses the LinRegInternal and LinReg functions to find the coefficients of the variables that determine the selling price of a home in a given neighborhood. The response variable, SellingPrice (the selling price of the house in dollars) is modeled on these independent (predictor) variables:

• House size (in square feet)
• Lot size (in square feet)
• Number of bedrooms
• Whether the kitchen counter is granite (0 or 1)
• Whether the bathrooms are upgraded (0 or 1)

Input

The LinRegInternal function skips the last row of housing_data because it contains a NULL value.

SQL Call

SELECT * FROM LinReg (
  ON LinRegInternal (
  ON housing_data
  ) PARTITION BY 1
) AS dt;

Output

 coefficient_name value_col           
 ---------------- ------------------- 
 Intercept        -21739.296665036818
 housesize        -26.930783509145726
 lotsize             6.33452410459345
 bedrooms           44293.76058418322
 granite            7140.676293495372
 upgradedbathroom   43179.19988882635

Download a zip file of all examples and a SQL script file that creates their input tables.