10. please answer 1-7 use the excel document on the left

Open recovered workbooks? Your recent changes Company Index Company Debt to Return on 1 lndel ' Capital ()1) Capital (as) 2 1 37.95 16.22 3 2 37.63 13.75 a 9 9.50 118.67 5 4 60.23 11.60 6 5 5.03 22.93 7 6 52.99 3.99 B 7 10.02 24.13 9 B 44.00 19.40 10 9 26.09 26.71 11 10 32.75 20.06 12 11 59.05 16.110 13 12 16.07 26.66 14 13 63.51 16.37 15 1a 4365 12,68 16 15 23.5! 20.85 17 16 20.81 23.13 16 1'! 63.19 -0 16 19 18 \".20 20.70 20 15 39.50 \".19 21 20 13.03 22.02 21 42.65 11.76 22 60.94 4.31 23 26.20 22 61 2: 37.39 13.69 25 64.90 6.00 26 41.56 5.37 27 13.75 21.60 26 64.35 6.12 29 51 61 16.02 33.98 13.85 Data Ready Page 1 o! S i: ,- Step 2: The data collected from the healthcare companies are given in an Excel le \"Exam 3 (DATA)? Run the regression model and, using the regression results, answer the following questions: k 1. Find the sample correlation between the return on capital [Choose ] V. and the debt-to-capital ratio. 2. Find the proportion of variation in the return on capital [ Choose ] V explained by the debt-to-capital ratio. 3. if the debt-to-capital ratio is increased by 1 unit (in this case I Choose 1 V. 1%). the return on capital will be 4. Find the upper limit ofa 95% condence interval for the population slope. 5. Consider company #1 where the debt-to-capital ratio - 37.95 I Choose 1 V. and the return on capital = 16.22. Find the predicted return on capital of the company. 6. Consider company #1 again. Find the residual of this observation, [ Choose ] V 7. How many potential outliers are in the data? 1 [Choose] V n v o s .a \"P Arm-w