RaqForum 43 No.
418 View  • 
     ...

MSE, RMSE, MAE, MAPE, R²

 

There are two columns in the Excel file, which are the predicted value and the true value of the house price in a certain area, and make the error assessment on it

SalePrice_predictvalue

SalePrice

205578.0852

208500

176323.4192

181500

217021.2719

223500

161173.8857

140000

281214.8513

250000

…

…


A

1

=T("houseprice_result.xls")

2

=mse(A1.(SalePrice_predictvalue),A1.(SalePrice))

3

=sqrt(A2)

4

=mae(A1.(SalePrice_predictvalue),A1.(SalePrice))

5

=A1.(abs((SalePrice_predictvalue-SalePrice)*100/SalePrice)).avg()

6

=1-A2/var(A1.(SalePrice))

A1 Import the data as a sequence table

A2 Calculate MSE

..

A3 Calculate RMSE

..

A4 Calculate MAE

..

A5 Calculate MAPE

..

A6 Calculate R²

..


 
 •  418 View  •