In the Excel file, create a time trend $($also called a counter$)$ and a dummy variable $($also called an indicator$)$ for each quarter. Start the time trend $/$counter at $1$ for first quarter of $2015.$ End the time trend$/$counter in the third quarter of $2020$

Run a regression$$that explains Dell$$s revenue.$$Use the time trend and quarterly dummies you created as explanatory variables.

What is r$-$squared value of the regression.

Date Stock Price Report Date Quarter Revenue in Millions

$9/1/2016$ $ $26\mathrm{.}4705/01/20151$ $ $12,838$

$10/1/2016$ $ $27\mathrm{.}1807/31/20152$ $ $12,975$

$11/1/2016$ $ $29\mathrm{.}6610/28/20153$ $ $12,674$

$12/1/2016$ $ $30\mathrm{.}4401/29/20164$ $ $12,679$

$1/1/2017$ $ $34\mathrm{.}8804/29/20161$ $ $12,534$

$2/1/2017$ $ $35\mathrm{.}1607/29/20162$ $ $13,050$

$3/1/2017$ $ $35\mathrm{.}4810/28/20163$ $ $16,247$

$4/1/2017$ $ $37\mathrm{.}1602/03/20174$ $ $20,074$

$5/1/2017$ $ $38\mathrm{.}4205/05/20171$ $ $17,816$

$6/1/2017$ $ $33\mathrm{.}8408/04/20172$ $ $19,299$

$7/1/2017$ $ $35\mathrm{.}5911/03/20173$ $ $19,610$

$8/1/2017$ $ $41\mathrm{.}4902/02/20184$ $ $21,935$

$9/1/2017$ $ $42\mathrm{.}7505/04/20181$ $ $21,356$

$10/1/2017$ $ $45\mathrm{.}8308/03/20182$ $ $22,942$

$11/1/2017$ $ $43\mathrm{.}3211/02/20183$ $ $22,482$

$12/1/2017$ $ $45\mathrm{.}0102/01/20194$ $ $23,841$

$1/1/2018$ $ $39\mathrm{.}7005/03/20191$ $ $21,908$

$2/1/2018$ $ $41\mathrm{.}1408/02/20192$ $ $23,370$

$3/1/2018$ $ $40\mathrm{.}5411/01/20193$ $ $22,844$

$4/1/2018$ $ $39\mathrm{.}7401/31/20204$ $ $24,032$

$5/1/2018$ $ $44\mathrm{.}6605/01/20201$ $ $21,897$

$6/1/2018$ $ $46\mathrm{.}8307/31/20202$ $ $22,733$

$7/1/2018$ $ $51\mathrm{.}2310/30/20203$ $ $23,482$

$8/1/2018$ $ $53\mathrm{.}25$

$9/1/2018$ $ $53\mathrm{.}78$

$10/1/2018$ $ $50\mathrm{.}05$

$11/1/2018$ $ $58\mathrm{.}41$

$12/1/2018$ $ $48\mathrm{.}87$

$1/1/2019$ $ $48\mathrm{.}59$

$2/1/2019$ $ $55\mathrm{.}82$

$3/1/2019$ $ $58\mathrm{.}69$

$4/1/2019$ $ $67\mathrm{.}41$

$5/1/2019$ $ $59\mathrm{.}55$

$6/1/2019$ $ $50\mathrm{.}80$

$7/1/2019$ $ $57\mathrm{.}74$

$8/1/2019$ $ $51\mathrm{.}53$

$9/1/2019$ $ $51\mathrm{.}86$

$10/1/2019$ $ $52\mathrm{.}89$

$11/1/2019$ $ $48\mathrm{.}49$

$12/1/2019$ $ $51\mathrm{.}39$

$1/1/2020$ $ $48\mathrm{.}77$

$2/1/2020$ $ $40\mathrm{.}46$

$3/1/2020$ $ $39\mathrm{.}55$

$4/1/2020$ $ $42\mathrm{.}69$

$5/1/2020$ $ $49\mathrm{.}64$

$6/1/2020$ $ $54\mathrm{.}94$

$7/1/2020$ $ $59\mathrm{.}83$

$8/1/2020$ $ $66\mathrm{.}08$

$9/1/2020$ $ $67\mathrm{.}69$

$10/1/2020$ $ $60\mathrm{.}26$

$11/1/2020$ $ $69\mathrm{.}03$

$12/1/2020$ $ $73\mathrm{.}29$

$1/1/2021$ $ $72\mathrm{.}89$

$2/1/2021$ $ $79\mathrm{.}69$