- G H 1 K Year L 1 Q2 7 34 Q1 6 49 7 04 7 62 2 Q3 7 11 7 69 8 34 7 92 04 10 82 11 71 12 68 13 74 3 4 8 25 8 58 9 29 10 08 1 (34.02 KiB) Viewed 65 times
- G H 1 K Year L 1 Q2 7 34 Q1 6 49 7 04 7 62 2 Q3 7 11 7 69 8 34 7 92 04 10 82 11 71 12 68 13 74 3 4 8 25 8 58 9 29 10 08 2 (32.68 KiB) Viewed 65 times
Problem:4) Hybrid cars have gained popularity because of their fuel economy and the uncertainty regarding the price of gasoline. All automakers, including the Ford Motor Co., have planned to significantly expand their hybrid vehicle line-up. The following table in Excel contains quarterly sales of Ford and Mercury hybrid cars. a. Compute seasonal indices. b. Compute seasonally adjusted data. c. Which model do you prefer? d. Estimate a linear trend model with seasonal dummy variables. e. Use the appropriate model to make quarterly forecasts for 6th year