7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
GLM Example 3 Model Statistics
predictor estimate std_error t_score p_value significance
(Intercept) 36349.3 2733.46 13.2979 0 ***
lotsize 2.08095 0.26133 7.96291 1.24345e-14 ***
bedrooms 782.093 766.84 1.01989 0.308296  
bathrms 6772.31 1106.78 6.11894 1.96318e-09 ***
stories 2445.62 694.145 3.52321 0.000467307 ***
garagepl 1483.1 623.597 2.3783 0.0177847 *
driveway.no -2822.63 1481.25 -1.90558 0.0573049 .
recroom.yes 1208.53 1358.57 0.88956 0.37415  
fullbase.yes 3588.3 1167.37 3.07382 0.00223419 **
gashw.yes 5787.25 2405.47 2.40587 0.0165127 *
airco.yes 6478.79 1152.16 5.62317 3.19341e-08 ***
prefarea.yes 6465.64 1212.84 5.33099 1.50887e-07 ***
homestyle.Classic -16550.9 1308.59 -12.6479 0 ***
homestyle.bungalow 37577.7 1850.17 20.3104 0 ***
ITERATIONS # 2 0 0 0 Number of Fisher Scoring iterations
ROWS # 492 0 0 0 Number of rows
Residual deviance Infinity 0 0 0 on 478 degrees of freedom
Pearson goodness of fit 5.30669e+10 0 0 0 on 478 degrees of freedom
AIC Infinity 0 0 0 Akaike information criterion
BIC Infinity 0 0 0 Bayesian information criterion
Wald Test 23174 0 0 0 ***
Dispersion parameter 1.11019e+08 0 0 0 Taken to be 1 for BINOMIAL and POISSON.

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;
GLM Example 3 Output Table glm_housing_model
attribute predictor category estimate std_err z_score p_value significance
-1 Loglik   -Infinity 492 13 0  
0 (Intercept)   36349.3 2733.46 13.2979 0 ***
1 lotsize   2.08095 0.26133 7.96291 1.24345e-14 ***
2 bedrooms   782.093 766.84 1.01989 0.308296  
3 bathrms   6772.31 1106.78 6.11894 1.96318e-09 ***
4 stories   2445.62 694.145 3.52321 0.000467307 ***
5 garagepl   1483.1 623.597 2.3783 0.0177847 *
6 driveway yes          
7 driveway no -2822.63 1481.25 -1.90558 0.0573049 .
8 recroom no          
9 recroom yes 1208.53 1358.57 0.88956 0.37415  
10 fullbase no          
11 fullbase yes 3588.3 1167.37 3.07382 0.00223419 **
12 gashw no          
13 gashw yes 5787.25 2405.47 2.40587 0.0165127 *
14 airco no          
15 airco yes 6478.79 1152.16 5.62317 3.19341e-08 ***
16 prefarea no          
17 prefarea yes 6465.64 1212.84 5.33099 1.50887e-07 ***
18 homestyle Eclectic          
19 homestyle Classic -16550.9 1308.59 -12.6479 0 ***
20 homestyle bungalow 37577.7 1850.17 20.3104 0 ***