Based on least squared regression method find the projection

Assignment Help Applied Statistics

Reference no: EM132927093

RESM301 Quantitative Methods

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. Decide which case values are better and why?
Assume trend is zero for the 2012 years.

Year	Number of sold cars
2012	150
2013	173
2014	166
2015	167
2016	180
2017	185
2018	190
2019	210
2020	199

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

Instructions:
- Submit the excel file ONLY using the VLE individual project link in the last week of the vle. The excel file can have your answers in text, graphs, tables and formulas. All in the same excel file please.

- Prepare slides and make a video presentation for the slides. Upload the video on a link in the last week of the vle. You need max of 5 slides to present your work. All should submit a video. If the video exceeds 2M (size), send it to me via email.

Attachment:- Common assessments.rar

Reference no: EM132927093

Questions Cloud

What is the importance of human resources planning : What is the importance of Human Resources planning?

Telespazio practices for performance appraisal interviews : What are Telespazio's Practices for Performance Appraisal Interviews and what changes can Telespazio could implement for their current Performance Appraisals?

Evaluate the effectiveness of teams in the workplace : Evaluate the effectiveness of teams in the workplace. Especially consider the unique challenges that teams face when trying to work effectively remotely.

Apply OLS regression with money supply measures : Calculate the year-to-year changes in the Federal funds rate and Create a correlation matrix using the results from (1) and (2)

Based on least squared regression method find the projection : 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)

Discuss your economic data you have collected : Discuss your economic data you have collected for the past 10 years and discuss what they have been doing regarding economic performance and problems

What is the company pre-tax WACC : A business requires an investment of € 30,000 and borrows € 7,500 at 7%. If the return on equity is 18%, what is the company's pre-tax WACC

Describe the factors limiting the internal validity of study : Describe the factors limiting the internal validity of this study and explain why those factors limit the ability to draw conclusions regarding cause-and-effect

How social structure theorists would view specific case : Describe how social structure or social process theorists would view this specific case. How social structure or social process theory apply to MS

User Account

All Pages