Please use excel and solver and take screenshots An analyst for Phidelity Investments wants to develop a regression model to predict the annual rate of return for a stock based on the price$-$earnings ratio of the stock and a measure of the stock's risk. The following data were collected for a random sample of stocks:

$\backslash$table$[[$PE RATIO,RISK,RETURN$],[7\mathrm{.}4,1\mathrm{.}0,7\mathrm{.}6],[11\mathrm{.}1,1\mathrm{.}3,13\mathrm{.}0],[8\mathrm{.}7,1\mathrm{.}1,8\mathrm{.}9],[11\mathrm{.}2,1\mathrm{.}2,10\mathrm{.}9],[11\mathrm{.}6,1\mathrm{.}7,12\mathrm{.}1],[12\mathrm{.}2,1\mathrm{.}3,12\mathrm{.}8],[12\mathrm{.}5,1\mathrm{.}2,11\mathrm{.}3],[12\mathrm{.}5,1\mathrm{.}3,14\mathrm{.}1],[13\mathrm{.}0,1\mathrm{.}6,14\mathrm{.}8],[13\mathrm{.}4,1\mathrm{.}4,16\mathrm{.}7]]$

a$.$ Prepare a scatter plot for each independent variable versus the dependent variable. What type of model do these scatter plots suggest might be appropriate for the data?

b$.$ Let $Y=$ Return; $x1=PE$ Ratio, and $x2=$ Risk. Fit a curve using the following equation: $Y_1=b_0+b_1{x}_{1_i}+b_2{x}_{2_i}+b_3{x}_{1_i}^2+b_4{x}_{2_i}^2$

c$.$ Is this a good fit? Why? Why not?