Please help me answer the following question. Thank you
Question 5
A B C 1 Price/Book Value Ratio Return on Equity Growth% 2 1.465 12.965 6.383 3 8.256 11.881 135.585 4 2.048 12.484 0.198 5 6.491 25.228 14.111 6 1.238 8.723 22.748 7 3.351 38.154 19.045 8 2.434 25.575 24.561 9 5.213 19.623 11.685 10 2.368 22.747 49.852 11 7.647 69.766 36.669 12 0.488 3.861 41.057 13 2.437 9.261 28.895 14 7.605 29.157 52.098 15 5.095 17.694 25.216 16 2.046 29.266 23.766 17 4.691 31.398 9.608 18 2.092 14.748 18.426 19 4.108 12.063 39.151 20 1.993 14.297 39.502 21 1.428 14.028 27.008 22 2.042 14.933 13.239 23 4.884 20.555 17.204 24 2.367 14.822 15.856 25 2.045 5.677 16.665 26 2.868 11.232 8.365 27 1.727 16.225 18.367 28 5.574 23.945 16.77429 4.658 14.787 46.605 30 2.518 6.306 34.122 31 1.695 18.942 8.514 32 8.343 38.878 15.028 33 2.133 15.272 25.185 34 2.929 19.818 0.255 35 7.368 18.343 3.235 36 3.222 20.568 9.527 37 2.861 34.694 7.152 38 2.532 15.486 9.415 39 1.243 10.284 4.627 40 3.086 23.557 4.012 41 10.139 91.606 13.372 42 1.948 1.674 15.949 43 1.615 9.383 5.692 44 1.959 19.373 0.027 45 7.219 4.882 102.756 46 1.293 42.858 1.543 47 5.636 90.918 74.073 48 6.435 19.401 8.911 49 2.638 27.284 34.447 50 3.334 13.067 12.239 51 6.898 24.586 11.482 52 13.675 82.002 24.496 53 4.031 1.514 20.273 54 7.089 3.655 22.197 55 6.177 31.495 49.816\fHomework: Module 12 - Multiple Regression Save Score: 0 of 1 pt 5 of 22 (18 complete) HW Score: 76.46%, 16.82 of 22 pts Instructor-created question Question Help A financial analyst engaged in business valuation obtained financial data on 71 drug companies. Let Y correspond to the price-to-book value ratio, X, correspond to the return on equity, and X2 correspond to the growth percentage. Use the accompanying data to complete parts a. through e. below. Click the icon to view the business valuation data. PLEASE RUN SPSS OR STATCRUNCH TO OBTAIN THE REQUIRED DATA TO ANSWER THE QUESTIONS BELOW! Be prepared to RUN SPSS OR STATCRUNCH in other questions in this module too! a. Develop a regression model to predict price-to-book-value ratio based on return on equity. (Round to four decimal places as needed.) b. Develop a regression model to predict price-to-book-value ratio based on growth. Y, = [+ X 21 (Round to four decimal places as needed.) c. Develop a regression model to predict price-to-book-value ratio based on return on equity and growth. Y1 = [+ X17 + X2 (Round to four decimal places as needed.) d. Compute and interpret the adjusted r for each of the three models. Start with the part (a) model. The adjusted r2 shows that % of the variation in is explained by correcting for the number of independent variables in the model. (Bound to nno dorimal place ac noodad )Homework: Module 12 - Multiple Regression Save Score: 0 of 1 pt 5 of 22 (18 complete) HW Score: 76.46%, 16.82 of 22 pt Instructor-created question Question Help A financial analyst engaged in business valuation obtained financial data on 71 drug companies. Let Y correspond to the price-to-book value ratio, X, correspond to the return on equity, and X2 correspond to the growth percentage. Use the accompanying data to complete parts a. through e. below. Click the icon to view the business valuation data. PLEASE RUN SPSS OR STATCRUNCH TO OBTAIN THE REQUIRED DATA TO ANSWER THE QUESTIONS BELOW! Be prepared to RUN SPSS OR STATCRUNCH in other questions in this module too! d. Compute and interpret the adjusted ~ for each of the three models. Start with the part (a) model. The adjusted r2 shows that % of the variation in is explained by V correcting for the number of independent variables in the model. (Round to one decimal place as needed.) Compute and interpret the adjusted r for the part (b) model. The adjusted r shows that % of the variation in is explained by correcting for the number of independent variables in the model. (Round to one decimal place as needed.) Compute and interpret the adjusted r for the part (c) model. The adjusted r2 shows that % of the variation in is explained by V correcting for the number of independent variables in the model. (Round to one decimal place as needed.) e. Which of these three models do you think is the best predictor of price-to-book-value ratio? The model from is the best predictor of price-to-book-value ratio because it has the value of
