Find five years of monthly returns (March 2016 March 2021) for the following firms: Sony, Cardinal Health, Inc., Black & Decker Corporation, Kellogg Company and Genzyme Corporation. Copy the returns from these five firms into a single Excel workbook, with the returns for each company properly aligned. Use the full range of available data. Then do the following:

a. Using the Excel functions for average (AVERAGE) and sample standard deviation (STDEV), calculate the average and the standard deviation of the returns for each of the firms.

b. Using Excel's correlation function (CORREL), construct the correlation matrix for the five stocks based on their monthly returns for the entire period. What are the lowest and the highest individual pairs of correlation coefficients? (Alternative: You may use Excel's Data Analysis Tool to generate the correlation matrix.)

Someone help me with this one please.