回归模型评估 - 残差图
残差residual=真实值-预测值
计算houseprice_result.xls中的残差并画图
A |
|
1 |
=T("houseprice_result.xls") |
2 |
=A1.derive(SalePrice-SalePrice_predictvalue:Residual) |
3 |
=canvas() |
4 |
=A3.plot("NumericAxis","name":"x") |
5 |
=A3.plot("NumericAxis","name":"y","location":2,"autoRangeFromZero":false) |
6 |
=A3.plot("Dot","lineWeight":0,"lineColor":-16776961,"markerWeight":1,"axis1":"x","data1":A2.(SalePrice),"axis2":"y","data2": A2.(Residual)) |
7 |
=A3.draw(800,400) |
A2 计算残差Residual
A3-A7 x轴取SalePrice,y轴取Residual画散点图即为残差图