Please solve and explain

Consider the following time series data.

Quarter	Year 1	Year 2	Year 3
1	4	6	7
2	2	3	6
3	3	5	6
4	5	7	8

a. Construct a time series plot. What type of pattern exists in the data?

b. Create the following dummy variables: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Create a variable t such that t = 1 for quarter 1 of year 1, t = 2 for quarter 2 of year 1, , t = 12 for quarter 4 of year 3. Use these dummy variables and t to develop an estimated regression equation to account for seasonal effects and any linear trend in the data. What is the forecast for quarter 1 of next year?

Answer options:

8.92

9.58

9.21

8.32

c. What is the forecast for quarter 2 of next year?

Answer options:

6.41

6.91

7.45

7.23

d. What is the forecast for quarter 3 of next year?

Group of answer choices

8.25

8.37

7.92

7.62

e. What is the forecast for quarter 4 of next year?

Answer options

10.19

9.62

9.92

10.38