Reference no: EM133082767

Year Q1 Q2 Q3 Q4 2014 . . 1,513 1,060 2015 1,431 1,123 994 679 2016...

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).
3. Create the trend variable (a variable that increases by 1 for each quarter of time that passes

To calculate the forecasted value for the third quarter of 2019, which answer shows the correct values for Q1, Q2, and Q3?

1. Q1=0, Q2=0, and Q3=1

2. Q1=0, Q2=0, and Q3=0

3. Q1=0, Q2=1, and Q3=0

4. Q1=1, Q2=1, and Q3=0