Question: Introduction: There are three sections for this project, in all the section make sure that you follow the exact instructions and round your answers to
Introduction: There are three sections for this project, in all the section make sure that you follow the exact instructions and round your answers to the mentioned decimal place. You are going to use R for section and but the answers for section Q and section Q will be written on the Airline data set on a separate sheet rename the sheet to "section& AnswersYou will submit your R script as a separate file. Section Smoothing Models using Excel Download the dataset Airlines from project resources folder. Part points Create a new column between Month and Actual columns by moving the Actual to column D cach row in the column created should contain name of the month and year for example, the entry of C should be Jan Part points Create a time series plot of Date Vs Actual using a line chart give it a proper title name Part C points: Correct initial values points, correct trend points, correct level points, correct seasons points, correct forecast points, correct MAD points, correct graph points Based on the graph you created above, decide which between the Holt Winter additive and Holt Winter multiplicative models is the right model for this type of the data set. Click on new worksheet rename it PartC, copy columns Date and Actual to the new worksheet. Implement your decided model using alpha gammabcta; s and m Round all your parameters including the Ls bs Ss Forecast, Error and the MAD to decimal place example Your column C for Lt D for bt E for S F for F G for Error and H for MAD. At the end of MAD column compute the average of all the values in MAD column it is a small number between to Plot the Date Vs Actual & Forecast to observe
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
