ON EXCEL:

$1.$ Create a linear regression model to predict ACP, using TD $=\{1...29\}$ as the predictor.

$2.$ Calculate and report the train Root Mean Squared Error $($RMSE$)$ and Coefficient of Determination $($R$2)$ of the model.

$3.$ Calculate and report the predicted price for the $11$th December $2023($PP$11),$ using the above model.

$4.$ Calculate and report the predicted Gain Per Share $($GPS$),$ as the difference between the predictions for $22$nd December and $11$th December.

$5.$ The R$2$ of the model is an indicator of the precision of the model, and of trust in its predictions. As such, report a Weighted Gain Per Share $($WGPS$),$ which is calculated simply as GP S $$ R$2.$