The data set provided in the excel sheet represents the number of weekly visitor the LIVLAND amusement park for year $2022.$ The LIVLAND management team $t$ to determine the best quantitative forecasting technique. Your task is to support them by experimenting different techniques on last year's data.

Use Moving Average Method $($use data of the last three weeks$)(1$ point$)$

Use Weighted Moving Average $($use data of the last three weeks and use $0\mathrm{.}6,$ and $0\mathrm{.}1$ weighting factors for weeks from most recent to oldest$)(1$ point$)$

Use exponential smoothing factor and use smoothing constant $()$ as $0\mathrm{.}1($Take forecast for the first week as $2500)(1$ point$)$

Calculate and compare the Mean Absolute Deviations $($MAD$).$ Which method possibly work best in $2023?$ Why? $(1$ point$)$

Draw a graph to compare actual and forecast data for all techniques. $(1$ point$)$

Calculate MAD for smoothing constants $()$ from $0\mathrm{.}1-0\mathrm{.}9$ with $0\mathrm{.}1$ increments. the lowest MAD. $(1$ point$)$

Draw the smoothing factor vs MAD chart. Which smoothing factor works bett Explain your reasoning. $(1$ point$)$

Please make your calculations in MS Excel but your submission as PDF file in prop professional look.