Copy the data onto sheets titled Average Model, 3 Month MA Model, 6 Month MA Model, and 12 Month MA Model. Create the 3 Moving Average Models: 3 month MA; 6 month MA and 12 month MA. For each model, find the Root MSE by finding each data forecast error, squaring it, calculating the average of all the errors squared (MSE), then taking the square root of the MSE to determine Root Mean Squared Error (RMSE). Five decimal places for all calculation results.

Using this data: Period M01 MO2 MO3 M04 MOS M06 M07 M08 M09 M10 M11 M12 M01 M02 M04 M05 M06 M07 M08 M09 M10 M11 M12 M01 M02 MO3 M04 MOS M06 M07 M08 M09 M10 M11 M12 M01 MO2 M03 M04 MOS M06 M07 M08 M09 M10 M11 M12 M01 Price 2.547 2.537 2.541 2.548 2.537 2.516 2.477 2.544 2.742 2.761 2.873 2.886 2.965 3.007 2.973 3.051 3.197 3.245 3.226 3.211 3.243 3.335 3.292 3.155 3.015 2.985 3.063 3.129 3.189 3.104 3.078 3.030 3.033 3.086 3.090 3.089 3.078 2.980 2.818 2.605 2.515 2.508 2.514 2.503 2.496 2.460 2.441 2.543 2.661