Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use Excel to answer this question End of month Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Risk-free 0.442% 0.436% 0.452% 0.413% 0.450% Rates of return Share index
Use Excel to answer this question
End of month Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Risk-free 0.442% 0.436% 0.452% 0.413% 0.450% Rates of return Share index Share A -1.710% 4.786% 3.337% -0.627% 0.023% 0.076% 1.799% -0.799% 0.141% 0.316% 0.028% 3.806% -2.544% 4.211% -2.105% -4.441% -4.611% 4.062% -3.200% 2.082% -6.108% 1.839% 7.443% 0.132% Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 0.449% 0.384% 0.445% 0.387% 0.453% 0.366% 0.308% (a) Calculate the monthly excess returns of the Share index and Share A. (b) Add a graph of the excess returns of Share A on the vertical axis (Y axis) and the Share index on the horizontal axis (X axis). On this graph, plot the linear regression line and display the regression equation and the R-squared. (c) Using appropriate Excel functions to calculate the Alpha, Beta and R-squared of the regression of the excess returns of the Share index on the excess returns of Share A. Provide a brief explanation on what these quantities measureStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started