(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) : ---- case1 use : = 0.2 and = 0.05 ---- case2 use: for = 0.05 and = 0.2 Calculate MAD for both cases (5 points) . Decide which case values are better and why? (5 points) Assume trend is zero for the 2012 years. Year Number of sold cars 2012 (140) cars 2013 (153) cars 2014 (166) cars 2015 (144) cars 2016 (180) cars 2017 (199) cars 2018 (190) cars 2019 (216) cars 2020 (178) cars 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. (10%). Explain in Excel step by step Thanks