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

(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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Quantitative Methods RESM 3 0 1 Spring 2 0 2 4 Virtual Lab ( % 2 0 ) : ( USE ONLY EXCEL SHEET FOR DATA, FORMULAS, and the GRAPHS ) For the following list of data ( number of sold cars in every year )...

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

For the following list of data (number of sold cars in every year), apply "exponential smoothing foresting with trend" for the first 4 years only. (i.e find the Forecast including trend) : use: a=...

Im Looking for question number 2 The Excel file AnEx #3 data file.xlsx provides quarterly data on a motel chain's sales revenue and advertising expenditures over the last 5 years. The goal is to...

Im looking for number 4 The Excel file AnEx #3 data file.xlsx provides quarterly data on a motel chain's sales revenue and advertising expenditures over the last 5 years. The goal is to predict the...

1 Use data in Worksheet Q1-9 to answer questions 1 to 9. The data is for a sample of dealerships and was collected for the second week of August 2016. Which variables are qualitative? A. New Car...

For the following list of data (number of sold cars in every year), apply "exponential smoothing with trend" for all the years below. (ie find the Forecast including trend): case1 use: a=0.02 and...

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 : =...

My question is the highlighted part in blue. For the following list of data (number of sold cars in every yeard, apply "exponential smoothing with trend" for all the years below. (i.e find the...

There are many ways to forecast the future. In many companies (especially small ones), the entire process is subjective, involving improvised methods, intuition, and years of experience. There are...

Maria Callas Co. is considering switching from the specific goods LIFO approach to the dollar-value LIFO approach. Because the financial personnel at Callas know very little about dollar-value LIFO,...

Which of the following is not a basic step in modeling process decision requirements? Multiple Choice Document decisions and how they impact business objectives. Specify decision information and...

An important rule is that you should never show a nominal rate on a time line or use it in calculations unless what condition holds

1. (Tor F) Other things being the same, depositors can cam more interest under continuous compounding than under daily compounding. 2. (Tor F) According to the perpetuity model (or constant growth...

What in the consulting process became ineffective? What may have been the reasons?

At what level(s) was this OD intervention scoped?

What in the OD process consultation went well? Provide reasons for your answer.