Question: Given the following gasoline consumption data.

(a) Estimate a multiple regression with trend and seasonal dummy variables. (10 points)

(b) Predict gasoline consumption for every quarter in the fourth year. (5 points)

(Tips: First, the data table needs to be reformatted into “year,” “quarter”, “gasoline” three columns. Then create a trend variable and dummy variables for quarters)