Redan, Inc., is expected to maintain a constant 5.7 percent growth rate in its dividends, indefinitely If the company has a dividend yield of 4.2 percent, what is the required return on the company's stock? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Required return % 1 Attached Excel file, HWS_Data.xlsx, contains real estate data with observations of variables Price and Size. Using Data Analysis Toolpak, run a simple regression using Price as the dependent (response) variable, and answer the following questions. 1) What are the values of beta coefficients? 2) What is the interpretation of the intercept? 3) What is the interpretation of the slope? 4) Compute the t statistic for the slope. 5) Compute a 90% confidence interval for the slope. 6) Which type of hypothesis test is used for the beta coefficient for the slope, write down the null and alternative hypothesis. 7) What is the p value for the test that is used for the beta coefficient for the slope? 8) Comment on the meaning of the p value of the slope and the outcome of the respective test. 9) What is the F test statistic value? Comment on the outcome of the respective test. 10) What is the value of the coefficient of determination? Comment on its meaning