(Steps Shown) Given the following gasoline consumption data. Quarter Year 1 Year 2 Year 3 1 150 156 175 2 140 148 156 3 185 201 208 4 160 175 185 Estimate
Question: Given the following gasoline consumption data.
| Quarter | Year 1 | Year 2 | Year 3 |
| 1 | 150 | 156 | 175 |
| 2 | 140 | 148 | 156 |
| 3 | 185 | 201 | 208 |
| 4 | 160 | 175 | 185 |
- Estimate a multiple regression with trend and seasonal dummy variables. (10 points)
- 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)
Price: $2.99
Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document 