Target Corporation:

Date Quarterly Sales

Oct$-1116,402$

Jan$-1221,288$

Apr$-1216,867$

Jul$-1216,779$

Oct$-1216,929$

Jan$-1322,726$

Apr$-1316,706$

Jul$-1317,117$

Oct$-1317,258$

Jan$-1421,515$

Apr$-1417,050$

Jul$-1417,406$

Oct$-1417,732$

Jan$-1521,751$

Apr$-1517,119$

Jul$-1517,427$

Oct$-1517,613$

Jan$-1621,626$

Apr$-1616,196$

Jul$-1616,169$

Oct$-1616,441$

Jan$-1720,690$

Apr$-1716,017$

Jul$-1716,429$

Oct$-1716,667$

Jan$-1822,766$

Apr$-1816,781$

Jul$-1817,776$

Oct$-1817,821$

Jan$-1922,977$

Apr$-1917,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 Q$3,$ with January is considered Q$4,$ with April is considered Q$1,$ and with July is considered Q$2.$ 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\mathrm{.}345$ then enter as $12\mathrm{.}35$ in the answer box.