Please use EXCEL to do this :

Final Studying Hours Allocation: You are preparing for the final exam, but the demands of your

job are consuming a significant amount of your time. You currently have only $30$ hours left for

focused study to prepare for the final. In order to study effectively, you have developed a multiple

linear regression model that relates the hours spent studying for specific topics: classification trees

and ensemble forecasting $($E$),$ clustering $($C$),$ and prescriptive analytics $($P$)$ to the improvement in

your final grade. Your model is represented by the equation:

Y $=2\mathrm{.}5$ E $+3\mathrm{.}1$ C $+3\mathrm{.}9$ P

Where Y represent your final exam grade.

In addition to your individual study plan, there is a review session scheduled for Thursday.

However, attending this session will require a total of $5$ hours, accounting for both commuting and

class time. If you choose to attend, the dynamics of your study model change, and the new

multiple linear regression model becomes:

Y $=3\mathrm{.}4$ E $+3\mathrm{.}5$ C $+4\mathrm{.}5$ P

The section of the exam related to classification trees and ensemble forecasting is worth $40$ points,

while the sections on clustering and prescriptive analytics are each worth $30$ points.

Your challenge is to strategically allocate your remaining time to these topics to maximize your

final grade.

How would you distribute your time? $($use the numbers that excel gave you to answer this$)$