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 2 and 3, but the answers for section 2 Q2 and section 3 Q2 will be written on the Airline data set on a separate sheet (rename the sheet to "section2&3 Answers)You will submit your R script as a separate file. Section 1(Smoothing Models using Excel) Download the dataset Airlines from project 4 resources folder. Part (10 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 C2 should be Jan-49). Part (10 points ) Create a time series plot of Date Vs Actual (using a line chart), give it a proper title name Part C (40 points: Correct initial values 10 points, correct trend 5 points, correct level 5 points, correct seasons 5 points, correct forecast 5 points, correct MAD 5 points, correct graph 5 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 =gamma=bcta=0.3,; s =12 and m =1 Round all your parameters ( including the Ls, bs, Ss, Forecast, Error and the MAD) to 4 decimal place (example 2.3242). Your column C for L(t), D for b(t), 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 10 to 20). 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 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 General Management Questions!