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.

$\backslash$table$[[$Year$,\backslash$table$[[$Number of sold$],[$cars$]]],[2012,107],[2013,113],[2014,150],[2015,133],[2016,151],[2017,173],[2018,189],[2019,200],[2020,215]]$

Based on least squared regression method find the projections for the years $2021,2022,$ and $2023.$ Plot the number of sold cars versus years $($points graph$)$ and show the trend line based on your projections. $(5\%).$