The following query returns the output shown in the following table:
SELECT * FROM glmpredict_housing ORDER BY 1;
sn | price | fitted_value |
---|---|---|
13 | 27000 | 37345.844 |
16 | 37900 | 43687.13175 |
25 | 42000 | 40902.028 |
38 | 67000 | 72487.6705 |
53 | 68000 | 79238.6937 |
104 | 132000 | 111528.007 |
111 | 43000 | 39102.8812 |
117 | 93000 | 66936.951 |
132 | 44500 | 41819.8865 |
140 | 43000 | 41611.7915 |
... | ... | ... |
The fitted_value column gives the predicted home price.