excel help

File Home Insert Draw Page Layout Formulas Data Review View A simple linear tegression modet to be approprlate. b. Davelop an estirnoted muit ple regression ecusson with x= rarity rating and z2 as the two independent variables. Price =+ Rating + (to whole numberis) What is the value of the coafficient af dectrmingsisn? Nater fepcrt R2 between 0 and 1 . (to 3 decimsis) What is the value of the Elest statistic? (to 2 decimais) What is the pryalue? (co4 decimais) c. Consider the nontinear reiatienship shown ty equatisn E(y)=d0g14+ Use logsenthms to develog an astimas regressisn equation foe this model. log(P+ice)= c. Consider the nonlinear relationship shown by equation E(y)=01x. Use logarithms to develop an estimated regression equation for this model. log( Price )= (to 3 decimals) log (Rating) What is the value of the coefficient of determination? Note: report R2 between 0 and 1 . (to 3 decimals) What is the value of the F test statistic? (to 2 decimals) What is the p-value? (to 4 decimais) d. Do you prefer the estimated regression equation developed in part (b) or part (c)? Explain. The model in part is preferred because it provides a better fit. File Home Insert Draw Page Layout Formulas Data Review View A simple linear tegression modet to be approprlate. b. Davelop an estirnoted muit ple regression ecusson with x= rarity rating and z2 as the two independent variables. Price =+ Rating + (to whole numberis) What is the value of the coafficient af dectrmingsisn? Nater fepcrt R2 between 0 and 1 . (to 3 decimsis) What is the value of the Elest statistic? (to 2 decimais) What is the pryalue? (co4 decimais) c. Consider the nontinear reiatienship shown ty equatisn E(y)=d0g14+ Use logsenthms to develog an astimas regressisn equation foe this model. log(P+ice)= c. Consider the nonlinear relationship shown by equation E(y)=01x. Use logarithms to develop an estimated regression equation for this model. log( Price )= (to 3 decimals) log (Rating) What is the value of the coefficient of determination? Note: report R2 between 0 and 1 . (to 3 decimals) What is the value of the F test statistic? (to 2 decimals) What is the p-value? (to 4 decimais) d. Do you prefer the estimated regression equation developed in part (b) or part (c)? Explain. The model in part is preferred because it provides a better fit