NOTE: . indicates missing value, do not include those quarters when you create the data in Excel.

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.In MS Excel's Regression tool, which variable should be the "Input Y Range" variable?

a.Q3

b.Trend

c.Visits

d.Q1

2.In this problem (which is set up the same as the forecasting example video), which quarter is the baseline (reference category) for the dummy variables representing the quarter in which each value occurred?

a.Q2

b.Q3

c.Q4

d.Q1

3.The forecasted value for the 3rd quarter of 2019 using a two-period moving average is

Select one:

a.1022

b.776.5

c.1095.5

d.1169

4.The forecasted value for the 3rd quarter of 2019 using a four-period moving average is

Select one:

a.1095.5

b.1071.25

c.907.33

d.1047

5.If the third quarter value for 2019 is actually observed to be 1,198, which forecasting method (the two-period moving average, the four-period moving average, or the seasonalized regression analysis), resulted in a forecasted value closest to the actual observed value?

a.seasonalized regression

b.four-period moving average

c.two-period moving average

d.All of the methods were equally close to the actual observed value for Q3 of 2019.