Search for question
Question

Need to develop excel graphs to answer the following assignment questions. Gallup conducted monthly surveys of the expectations of individual investors. The accompanying Excel document “Gallup Data” lists the mean stock returns expected by individual investors during the following 12 months. You also have the actual returns of the S&P 500 Index during the preceding and following 12-month periods. 1. Using regression, find the association between the mean stock returns expected by individual investors during the following 12 months and the actual return during the preceding 12 months. a. What association do you see? b. How strong is the association? (What is the R-Squared?). Draw the regression line and scatter diagram. 2. Using regression, find the association between the mean stock returns expected by individual investors during the following 12 months and actual returns during the following 12 months. a. b. What association do you see? How strong is the association? (What is the R-Squared?). Draw the regression line and scatter diagram. The answer for part 1 and part 2 should be on seperate sheets within the excel file

Fig: 1