(USE ONLY EXCEL SHEET FOR DATA, FORMULAS, and the GRAPHS) > For the following list of data (number of sold cars in every

[answerhappygod]

Use Only Excel Sheet For Data Formulas And The Graphs For The Following List Of Data Number Of Sold Cars In Every 1 (54.64 KiB) Viewed 13 times

(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: a = 0.2 and B=0.04 ---- case2 use: for a= 0.1 and B=0.2 Calculate MAD for both cases (5 %). Decide which case values are better and why? (5 %) Assume trend is zero for the 2012 years. Year 2012 2013 2014 2015 2016 2017 2018 2019 2020 Number of sold cars Instructions: 114 163 140 154 180 190 195 240 315 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%). You need to upload ppt slides of the project. (5%) ► Submit the excel file +ppt presentation slides over the VLE virtual lab link. The excel file can have your answers in text, graphs, tables and formulas. All in the same excel file please. (All Due in week 6). There will be no presentations. You need only to upload the slides with voice to describe your work using the same link of the report available on the vle (last week activities) You need max of 5 slides to present your work. All should prepare and upload slides.