Using the TGT Quarterly Sales (Target Corp.) data:

• Fit a regression model with a time trend and seasonal dummy variables to the sales data.
• Is the time trend coefficient statistically significant? Are the seasonal dummy variables statistically significant? Insert a text box in the sheet to briefly answer this question.

Note that Target's quarter end is not March/June/September/December, but a month later. April's data will reflect the sales in Q1, July will reflect Q2, October will reflect Q3, January will reflect Q4. You can use IF function to determine which quarter it is.

DateSales (Y)Oct-1116,402Jan-1221,288Apr-1216,867Jul-1216,779Oct-1216,929Jan-1322,726Apr-1316,706Jul-1317,117Oct-1317,258Jan-1421,515Apr-1417,050Jul-1417,406Oct-1417,732Jan-1521,751Apr-1517,119Jul-1517,427Oct-1517,613Jan-1621,626Apr-1616,196Jul-1616,169Oct-1616,441Jan-1720,690Apr-1716,017Jul-1716,429Oct-1716,667Jan-1822,766Apr-1816,781Jul-1817,776Oct-1817,821Jan-1922,977Apr-1917,627