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

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

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

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

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

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

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

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