Dear Tutor,

hopefully, you are doing well.

I am really struggling with the following assignment (homework), and I have no idea where and how to start it.

Please see assignment below.

" In this problem, you goal is to assess the extent to which market conditions changed as a result of theCovid-19 pandemic. The fileAssignment3-Data.xlscontains monthly returns for two assets (Tesla and Bitcoin) from February 2015 to December 2020.

(a) Split the data into two subsamples: (i) February 2015 to December 2019 as a proxy for the pre-Covid era and (ii) January 2020 to December 2020 to approximate the post-Covid era. Calculate the pre-and post-Covid average return and pre- and post-Covid standard deviation of the returns of Tesla and Bitcoin.

(b) Calculate the pre- and post-Covid correlations between the returns of Tesla and Bitcoin. What do you conclude?

Relevant data is accessible here: https://www.coursehero.com/file/109959448/Assingment-3-Dataxlsx/

How to approach this assignment? What should I use?

Thank you very much for all your help!