Year	Q1	Q2	Q3	Q4
2014	.	.	1,513	1,060
2015	1,431	1,123	994	679
2016	1,485	886	1,256	975
2017	1,256	1,156	1,163	1,062
2018	1,200	1,072	1,563	531
2019	1,022	1,169	.	.

1. Enter the data in MS Excel, as demonstrated in the example video (data should be in columns, with a header row to clearly identify the data in each column).
2. Create dummy variables for Q1, Q2, and Q3 (you do not need a Q4 variable, as discussed and demonstrated in the example video)

The forecasted value for the 4th quarter of 2019 is

Select one:

a.

1194.169

b.

1197.781

c.

1004.263

d.

769.070