Question: please check all photos Instructions Risk and Return Assignment Data.xlsx Use the data above to complete this assignment. In the Excel file, you have two



Instructions Risk and Return Assignment Data.xlsx Use the data above to complete this assignment. In the Excel file, you have two monthly price series, one for S\&P500 index (the market index) and another one for Apple, Inc from 2014-2019. Given the price series, compute the monthly return series for each column. Then, compute the variance and covariance of the corresponding time period for each series (as given in the data sheet). Use the Excel function var.s and covariance.s. Record your numerical answers (up to 0.00001 accuracy) in the quiz for this assignment. You have 1 attempt, so please record your answers when you're ready to submit. Risk and Return Assignment Data-2.xl... Variance of ^ GSPC in 2014-2018 Between 0.0009 and 0.001 Question 2 0/2.5pts Variance of APPL in 2015-2019 Between 0.005 and 0.006 Covariance of ^ GSPC and APPL in 2014-2018 Between 0.001 and 0.002 Question 4 0/2.5 pts Covariance of ^ GSPC and APPL in 2015-2019
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
