$1$:$13$

Virtual Lab $(20\%)-$ Spring $2...$

HBMSU

Quantitative Methods RESM$301$

Spring $2024$

Virtual Lab $(\%20)$:

$($USE ONLY EXCEL SHEET FOR DATA, FORMULAS, and the GRAPHS$)$

$>$ For the following list of data $($number of sold cars in every year $),$ apply "exponential smoothing with trend" for all the years below. $($i$.$e find the Forecast including trend$)$ :

$---$ case $1$ use : $=0\mathrm{.}01$ and $=0\mathrm{.}3$

$----$ case $2$ use: for $=0\mathrm{.}1$ and $=0\mathrm{.}05$

Calculate MAD for both cases $(5\%).$

Decide which case values are better and why? $(5\%)$

Assume trend is zero for the $2012$ years.

Year Number of sold

cars

$2012107$

$2013113$

$2014150$

$2015133$

$2016151$

$2017173$

$2018189$

$2019200$

$2020215$