Target Corporation:
Date Quarterly Sales
Oct-11 16,402
Jan-12 21,288
Apr-12 16,867
Jul-12 16,779
Oct-12 16,929
Jan-13 22,726
Apr-13 16,706
Jul-13 17,117
Oct-13 17,258
Jan-14 21,515
Apr-14 17,050
Jul-14 17,406
Oct-14 17,732
Jan-15 21,751
Apr-15 17,119
Jul-15 17,427
Oct-15 17,613
Jan-16 21,626
Apr-16 16,196
Jul-16 16,169
Oct-16 16,441
Jan-17 20,690
Apr-17 16,017
Jul-17 16,429
Oct-17 16,667
Jan-18 22,766
Apr-18 16,781
Jul-18 17,776
Oct-18 17,821
Jan-19 22,977
Apr-19 17,627
Using the Target Corporation Quarterly Sales data, fit a regression model with a time trend and three quarterly seasonal dummy variables to the Sales Data. Note that the Dates mark the ending month of each quarter; the date with October is considered Q3, with January is considered Q4, with April is considered Q1, and with July is considered Q2. Please calculate the intercept and coefficients as numbers to two decimal places.
Question 20) Use the regression model to forecast the quarterly sales for the July 2019 Quarter, which would be Period 32, the next period after your last Sales data for April 2019. Enter your answer rounded to two decimal places; do not enter a comma in the answer box. For example, if your answer is 12.345, then enter as 12.35 in the answer box.