1. Locate the stock price data on yahoo finance. Use closing price on a quarterly basis and calculate the average return of the stock from 2010 to 2019. [5%]
2. Similar to Question 4, calculate the average return on S&P 500 from 2010 to 2019. Calculate the correlation coefficient of quarterly returns between the stock selected and S&P 500. [5%]

just need example to see how to solve it. the workings should be in excel. I would like explanations using words and images.