An analyst in Phidelity Investments wants to develop a regression model to predict the annual rate of return for a stock

[answerhappygod]

An analyst in Phidelity Investments wants to develop a
regression model to predict the annual rate of return for a stock
based on the price-earnings (PE) ratio of the stock and a measure
of the stock's risk. The data found in the file Phidelity.xlsx were
collected for a random sample of stocks.
Q1.1. First read the data from the file.
In [ ]:
In [ ]:
Q1.2. Plot scatter plot for each independent variable versus
dependend variable.
In [ ]:
In [ ]:
Q1.3. Conduct a regression model for the following
equation. 𝑌=𝑏0+𝑎𝑋1+𝑏𝑋2Y=b0+aX1+bX2 where 𝑌Y is
Return, 𝑋1X1 is PE Ratio, and 𝑋2X2 is Risk.
In [ ]:
In [ ]: