I WANT DETAILED EXPLANATION REGARDGING THIS QUESTION EACH STEP OF EXCEL HOW TO DO IT PLEASE URGENT SUV sales data below has data on quarterly sales of number of four-wheel drive sports utility vehicles(SUV) sold at a dealership for the years 2014 thru 2016. Using Excels Data Analysis add-in, develop forecast sales for year 2017 using Excels forecast sheet for seasonal data. A) The dealership believes that there is a way to predict future demands for

the number od SUV sales using the exponential smoothing model. Develop such a model with an alpha of 0.1 and forecast the sales for 2017. Also develop a Mean absolute Deviation (MAD)metric for this prediction.

\begin{tabular}{cccc} Year & Quarter & Time & \begin{tabular}{c} Units \\ Sold \end{tabular} \\ \hline 2014 & 1 & 1 & 23 \\ & 2 & 2 & 25 \\ & 3 & 3 & 36 \\ & 4 & 4 & 31 \\ 2015 & 1 & 5 & 26 \\ & 2 & 6 & 28 \\ & 3 & 7 & 48 \\ 2016 & 4 & 8 & 36 \\ & 1 & 9 & 31 \\ & 2 & 10 & 42 \\ & 3 & 11 & 53 \\ & 4 & 12 & 43 \\ \hline \end{tabular}