Problem 6-25 Consider the following time series data. Choose the correct time series plot. (i)(ii)(iii)(iv) What type of pattern exists in the data? Use a multiple regression model with dum

Problem 6-25

Consider the following time series data.

1. Choose the correct time series plot.(i)(ii)(iii)(iv)What type of pattern exists in the data? 
2. Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)Value = fill in the blank 3 + fill in the blank 4 Qtr1 + fill in the blank 5 Qtr2 + fill in the blank 6 Qtr3 + fill in the blank 7 t 
3. Compute the quarterly forecasts for next year. If required, round your answers to two decimal places.Quarter 1 forecast = fill in the blank 8Quarter 2 forecast = fill in the blank 9Quarter 3 forecast = fill in the blank 10Quarter 4 forecast = fill in the blank 11