Data for a retail company's quarterly sales are shown below. Using Excel, develop a linear regression model predicting sales based on quarter only $($i$.$e$.$ no trend$).$ Be sure to use$/$create the necessary dummy variables for the quarters.

Time Year Quarter Sales

$12020182\mathrm{.}6$

$220202135\mathrm{.}6$

$320203120\mathrm{.}8$

$42020469\mathrm{.}7$

$52021168\mathrm{.}6$

$620212147\mathrm{.}1$

$720213144\mathrm{.}3$

$82021471\mathrm{.}9$

$92022157\mathrm{.}2$

$1020222120\mathrm{.}6$

$1120223112\mathrm{.}3$

$122022440\mathrm{.}4$

$132023151\mathrm{.}6$

$1420232158\mathrm{.}3$

$1520233129\mathrm{.}4$

$162023477\mathrm{.}7$

Download CSV

Round all answers to three decimal places if needed.

a$)$ What is the prediction for Quarter $1$ of $2024?$

Quarter $1$ Sales $=$

b$)$ What is the prediction for Quarter $2$ of $2024?$

Quarter $2$ Sales $=$

c$)$ What is the prediction for Quarter $3$ of $2024?$

Quarter $3$ Sales $=$

d$)$ What is the prediction for Quarter $4$ of $2024?$

Quarter $4$ Sales $=$