Using Excel, create a column that calculates error for each of the observations shown above.

Using Excel, create a column that calculates error for each of the observations shown above. Attach screenshot. [10 points)

a) Calculate RMSE for the table. [5 points)

b) Calculate MAE for the table. [5 points)