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;
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 | *** |