In Excel create a 4 period moving average with additive trend in excel using the below excel data. Optimize the model for the value of x that minimizes the MSE. Calculate the MSE for the model and next years prediction. What is the MSE for this model? (use 2 decimal places). Below is the excel data and the moving average that excel gave me. Just need to optimize the model for x and minimize MSE?

Time Period Stock Price mov avg \begin{tabular}{|r|l|l|} \hline 2000 & 70.23 & \#N/A \\ \hline 2001 & 72.39 & \#N/A \\ \hline 2002 & 72.93 & \#N/A \\ \hline 2003 & 73.65 & 72.30 \\ \hline 2004 & 73.65 & 73.16 \\ \hline 2005 & 74.27 & 73.62 \\ \hline 2006 & 74.22 & 73.95 \\ \hline 2007 & 74.47 & 74.15 \\ \hline 2008 & 74.99 & 74.48 \\ \hline 2009 & 75.95 & 74.91 \\ \hline 2010 & 76.51 & 75.48 \\ \hline 2011 & 77.79 & 76.31 \\ \hline 2012 & 78.35 & 77.15 \\ \hline 2013 & 79.41 & 78.01 \\ \hline 2014 & 80.46 & 79.00 \\ \hline 2015 & 80.53 & 79.69 \\ \hline 2016 & 80.99 & 80.35 \\ \hline 2017 & 81.56 & 80.89 \\ \hline 2018 & 82.21 & 81.32 \\ \hline \end{tabular}