Question: Forecasting Time Series & Simple Linear Regression $1.$ Given the following demand for antibiotics from patients attending a local clinic, please generate forecasts by arithmetic mean, last period value, MA $(3),$ MA $(5),$ ES $(0\mathrm{.}1),$ ES $(0\mathrm{.}4),$ and ES $(0\mathrm{.}9).$ Please calculate MAD and MSE for each forecasting method. Which forecasting method performs the best, theForecasting Time Series & Simple Linear Regression$1.$ Given the following demand for antibiotics from patients attending a local clinic, please generate forecasts by arithmetic mean, last period value, MA $(3),$ MA $(5),$ ES $(0\mathrm{.}1),$ ES $(0\mathrm{.}4),$ and ES $(0\mathrm{.}9).$ Please calculate MAD and MSE for each forecasting method. Which forecasting method performs the best, the worst? Please answer in Excel for your solutions.