need to develop excel graphs to answer the following assignment questi
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