Question 1:

With the same data set answer question 2

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 1 & Dat: & saten(m) & Aerien lesecist o) & tene. & Anelase trier & Seucesterer & & & & 4 & a & 1 & & \pm \\ \hline 2. & 13sen2020 & css & & & & & Me & B= & \\ \hline 3 & 10502020 & 2899 & & & & & vas & & & & & & & \\ \hline 4 & & & & & & & & & \\ \hline 8 & & 1511 & & & E & & & & & & & & & \\ \hline c & 17sen250 & 5233 & & & & (n) & & & & & & & & \\ \hline ? & 21lep2000 & 457 & & & & & & & & & & & & \\ \hline & 19log2600 & aits & & & & & & & & & & & & \\ \hline 3 & 20lop2070 & 249 & & & & & & & \\ \hline 10 & 21sen2020 & 3m1 & & & & & & & & & & & & \\ \hline 11 & 22sen2020 & 3061 & & & & & & & \\ \hline & 31502020 & & & & & & & & & & & & & \\ \hline 13 & 245002030 & 2107 & & & 41 & E & & & \\ \hline 14 & 78502020 & & & & & & & & & & & & & \\ \hline is & 26lep2390 & & * & & & & & & \\ \hline 36 & in lep 20010 & nit. & & & & & & & & & & & & \\ \hline i) & 21 Sepposo & mo & & & & & & & & & & & & \\ \hline it & rosepreas & & & & = & & & & & & & & & \\ \hline is & 30 lep2006 & sin0 & & & & & & 10 & & & & & & \\ \hline 20 & 010012050 & 6in & 7 & & & & & & & & & & & \\ \hlinen & oq ont ross & bet? & & & & & & & & & & & & \\ \hlinen & 01012035 & 651 & & 11 & & & & & & & & & & \\ \hlinen & ofot3ops. & 3m & & & & & & & & & & & & \\ \hline 24 & oseriors & 203 & & & & & & & & & & & . & \\ \hline as & 060+2020 & & & 4 & & & & & & , & & & & \\ \hline 26 & 010+1020 & and & & & & & & & & & & & & \\ \hline 31 & & 3804 & & & & & & & & & & & & \\ \hline 31 & osatroso & 447 & & & & & & & & & & & & \\ \hline n. & 100t2000 & root & & & & & & & & & & & & \\ \hline 30 & 210 an 3900 & 30H & & & & & & & & & & & & \\ \hline 11 & trat 2eas & 3434 & & & & & & & & & & & & \\ \hline ut & 110arab & sim & & & & & & & & & & & & \\ \hline 3 & 140+3000 & 3601 & & & - & & & & & & & & & \\ \hline 34 & wart 2500 & 431 & & 3 & & E & & & & 1 & & & & \\ \hline 35 & 15007000 & 9014 & & & & z & & & & & & & & \\ \hline 35 & 17003020 & 140 & E- & & & & & & & & & & & \\ \hline in & 310002000 & & & & & & & & & 7 & z & & & \\ \hline 3 & & tots. & & & & & & & & & & & & \\ \hline 38 & 20 arinso & nis & & & & & & & & & & & & \\ \hline Ao & 2100+250 & & & & & & & & & & & & & \\ \hline 4 & nocrposo & am & & & & & & & & & & & & \\ \hline \end{tabular} The data alongside gives the date and sales for a retail company. Answer the following 6 questions: a) Use the weighted average method to estimate the sales for November 1. (use span =5 ) b) Estimate the forecast for entire dataset using weighted average method, (use span =5 ) c) Create a line plot showing both Y and F for the entire time duration in the given dataset d) Find the error using the formula Y,F e) Calculate absolute Error and Squred Error f) Calculate MAE, MSE, and RMSE g) Out of the 3 methods (question 3a,3b, and 3c), which one is the best and why? \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 1 & Dat: & saten(m) & Aerien lesecist o) & tene. & Anelase trier & Seucesterer & & & & 4 & a & 1 & & \pm \\ \hline 2. & 13sen2020 & css & & & & & Me & B= & \\ \hline 3 & 10502020 & 2899 & & & & & vas & & & & & & & \\ \hline 4 & & & & & & & & & \\ \hline 8 & & 1511 & & & E & & & & & & & & & \\ \hline c & 17sen250 & 5233 & & & & (n) & & & & & & & & \\ \hline ? & 21lep2000 & 457 & & & & & & & & & & & & \\ \hline & 19log2600 & aits & & & & & & & & & & & & \\ \hline 3 & 20lop2070 & 249 & & & & & & & \\ \hline 10 & 21sen2020 & 3m1 & & & & & & & & & & & & \\ \hline 11 & 22sen2020 & 3061 & & & & & & & \\ \hline & 31502020 & & & & & & & & & & & & & \\ \hline 13 & 245002030 & 2107 & & & 41 & E & & & \\ \hline 14 & 78502020 & & & & & & & & & & & & & \\ \hline is & 26lep2390 & & * & & & & & & \\ \hline 36 & in lep 20010 & nit. & & & & & & & & & & & & \\ \hline i) & 21 Sepposo & mo & & & & & & & & & & & & \\ \hline it & rosepreas & & & & = & & & & & & & & & \\ \hline is & 30 lep2006 & sin0 & & & & & & 10 & & & & & & \\ \hline 20 & 010012050 & 6in & 7 & & & & & & & & & & & \\ \hlinen & oq ont ross & bet? & & & & & & & & & & & & \\ \hlinen & 01012035 & 651 & & 11 & & & & & & & & & & \\ \hlinen & ofot3ops. & 3m & & & & & & & & & & & & \\ \hline 24 & oseriors & 203 & & & & & & & & & & & . & \\ \hline as & 060+2020 & & & 4 & & & & & & , & & & & \\ \hline 26 & 010+1020 & and & & & & & & & & & & & & \\ \hline 31 & & 3804 & & & & & & & & & & & & \\ \hline 31 & osatroso & 447 & & & & & & & & & & & & \\ \hline n. & 100t2000 & root & & & & & & & & & & & & \\ \hline 30 & 210 an 3900 & 30H & & & & & & & & & & & & \\ \hline 11 & trat 2eas & 3434 & & & & & & & & & & & & \\ \hline ut & 110arab & sim & & & & & & & & & & & & \\ \hline 3 & 140+3000 & 3601 & & & - & & & & & & & & & \\ \hline 34 & wart 2500 & 431 & & 3 & & E & & & & 1 & & & & \\ \hline 35 & 15007000 & 9014 & & & & z & & & & & & & & \\ \hline 35 & 17003020 & 140 & E- & & & & & & & & & & & \\ \hline in & 310002000 & & & & & & & & & 7 & z & & & \\ \hline 3 & & tots. & & & & & & & & & & & & \\ \hline 38 & 20 arinso & nis & & & & & & & & & & & & \\ \hline Ao & 2100+250 & & & & & & & & & & & & & \\ \hline 4 & nocrposo & am & & & & & & & & & & & & \\ \hline \end{tabular} The data alongside gives the date and sales for a retail company. Answer the following 6 questions: a) Use the weighted average method to estimate the sales for November 1. (use span =5 ) b) Estimate the forecast for entire dataset using weighted average method, (use span =5 ) c) Create a line plot showing both Y and F for the entire time duration in the given dataset d) Find the error using the formula Y,F e) Calculate absolute Error and Squred Error f) Calculate MAE, MSE, and RMSE g) Out of the 3 methods (question 3a,3b, and 3c), which one is the best and why