| message |
|---|
| Successful. Result has been stored in table: '"diabetes_lasso"'. (2 rows) |
The following query returns the output shown in the following table:
SELECT * FROM diabetes_lasso WHERE steps <> 0 ORDER BY steps;
| steps | var_id | var_name | max_abs_corr | step_length | intercept | age |
|---|---|---|---|---|---|---|
| 1 | 3 | bmi | 949.435 | 60.1193 | 152.133 | 0 |
| 2 | 9 | ltg | 889.316 | 513.224 | 152.133 | 0 |
| 3 | 4 | map | 452.901 | 175.553 | 152.133 | 0 |
| 4 | 7 | hdl | 316.074 | 259.367 | 152.133 | 0 |
| 5 | 2 | sex | 130.131 | 88.6592 | 152.133 | 0 |
| 6 | 10 | glu | 88.7824 | 43.6779 | 152.133 | 0 |
| 7 | 5 | tc | 68.9652 | 135.984 | 152.133 | 0 |
| 8 | 8 | tch | 19.9813 | 54.0156 | 152.133 | 0 |
| 9 | 6 | ldl | 5.47747 | 5.56726 | 152.133 | 0 |
| 10 | 1 | age | 5.08918 | 41.9996 | 152.133 | -5.71894 |
| 11 | -7 | hdl | 2.18225 | 7.2707 | 152.133 | -7.01124 |
| 12 | 7 | hdl | 1.31044 | 27.97 | 152.133 | -10.0122 |
| sex | bmi | map | tc | ldl | hdl | tch | ltg | glu |
|---|---|---|---|---|---|---|---|---|
| 0 | 60.1193 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 0 | 361.895 | 0 | 0 | 0 | 0 | 0 | 301.775 | 0 |
| 0 | 434.758 | 79.2364 | 0 | 0 | 0 | 0 | 374.916 | 0 |
| 0 | 505.66 | 191.27 | 0 | 0 | -114.101 | 0 | 439.665 | 0 |
| -74.9165 | 511.348 | 234.155 | 0 | 0 | -169.711 | 0 | 450.667 | 0 |
| -111.979 | 512.044 | 252.527 | 0 | 0 | -196.045 | 0 | 452.393 | 12.0781 |
| -197.757 | 522.265 | 297.16 | -103.946 | 0 | -223.926 | 0 | 514.75 | 54.7677 |
| -226.134 | 526.885 | 314.389 | -195.106 | 0 | -152.477 | 106.343 | 529.916 | 64.4874 |
| -227.176 | 526.391 | 314.95 | -237.341 | 33.6284 | -134.599 | 111.384 | 545.483 | 64.6067 |
| -234.398 | 522.649 | 320.343 | -554.266 | 286.736 | 0 | 148.9 | 663.033 | 66.331 |
| -237.101 | 521.075 | 321.549 | -580.439 | 313.862 | 0 | 139.858 | 674.937 | 67.1794 |
| -239.819 | 519.84 | 324.39 | -792.184 | 476.746 | 101.045 | 177.064 | 751.279 | 67.6254 |
The following figure represents the results and shows how the standardized coefficients evolved during the model-building process. The x-axis represents the ratio of the norm of the current beta to the full beta. The y-axis represents the standardized coefficients, which are estimated when standardized predictors are used. The numbers on the top of the graph represent the steps of the model-building process. The numbers on the right represent the predictor IDs.
LASSO Results
