This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: using sets and tables. Also avoid writing multiple constraints when possible . 1. For question 1 you will have an excel file, solve it and save the solutions in the same worksheet after solved by solver. 2. For question 2, copy your GAMS code in notepad or word NEATLY. 3. You are not allowed to use any messenger or email account during the quiz. 4. You cannot contact your friends during the quiz. Q3. In ‘Quiz3-Q3.xlsx’ the annual data for finished motor gasoline supplied to the U.S. is provided. Using the moving average technique for: a) N = 4 years b) N = 8 years Calculate the forecast values. c) Calculate the MSE for N = 4 and 8 years using the error values. d) Plot the data (1947 to 2006) and forecasts together. e) Add a polynomial trendline on your forecast curve for N=8. Display the trendline’s equation. Good luck...
View Full Document
- Spring '08
- Alloy, Metalco Company