Please create new columns and cells in this data file (inHuman Computer Interaction Excel). You must create new columns containing formulas to calculate the Average of all seasons, Average of averages, Seasonal Factor, Deseasonalized Price and Reseasonalized Price, and any additional columns you may need. You will also have to create a few more additional cells (not entire columns) containing some formulas. All your new columns and cells must contain only formulas (except for the column names), i.e., when I double-click on any of these cells, I must be able to see the underlying Excel formula and not a number/value. Save this completed Excel file as Assignment_2.xlsx
- Once again, download the Gas Prices.xlsx file from the Assignment 2 link on Canvas. Then import this file (all 49 rows and 3 columns) into Stata using File…Import and then save this Stata data file as Assignment_2.dta (You can use the pwd command to see where this file has been saved on your laptop.)
Please write commands to create the following new columns in this Stata data file, based on the given information. For each column, the word before the colon must be assigned as the column name.
- MA: The (randomly chosen) October 2020 forecast should be the average of 2.277, 2.364, 2.435 and 2.271
- WMA: The (randomly chosen) October 2020 forecast should assign 20% weight to 2.277 and 80% weight to 2.364
- ES: α = 0.65; initial forecast is assumed to be the same as initial actual.
- OVERALLAVG: Overall average of all DollarsPerGallon
- SEASONALAVG: Average of each season
- SF: Seasonal Factors
- DSDPG: Deseasonalized DollarsPerGallon
- REG1: Predicted linear regression values of the appropriate dependent variable based on Period
- FINALDPG: Final predicted values of DollarsPerGallon using Time-Series Decomposition