Retrieve the file Risk Return Data.xls from Brightspace. The file contains monthly prices for Netflix (NFLX), McDonalds (MCD), Southwest Airlines (LUV), and the S&P 500 Index. Once you have retrieved the data, do the following:

a. Calculate monthly returns for each stock and the S&P 500 Index. The return for each month is calculated as:

Return = (End Price Begin Price + Dividend) / Begin Price,

However, because we are using adjusted returns, you will not have a dividend component and the return will be calculated as:

Return = (Adjusted End Price Adjusted Begin Price) / Adjusted Begin Price,

For example, the return for January is the January adjusted close price minus the December adjusted close price, divided by the December adjusted close price.

b. Calculate the arithmetic average monthly return and standard deviation of returns for all stocks and the S&P 500 index. Make sure to use the sample standard deviation. The Excel function for sample standard deviation is STDEV.S or STDEV.

c. Calculate the correlation between the returns for all pairs of stocks and between each stock and the S&P 500.

Date	NFLX	MCD	LUV	S&P500
9/1/2015	103.260002	90.730072	37.058002	1920.03003
10/1/2015	108.379997	103.363953	45.095032	2079.36011
11/1/2015	123.330002	105.122742	44.695614	2080.40991
12/1/2015	114.379997	109.64064	41.94841	2043.93994
1/1/2016	91.839996	114.874893	36.704365	1940.23999
2/1/2016	93.410004	108.758995	40.928982	1932.22998
3/1/2016	102.230003	117.52182	43.709614	2059.73999
4/1/2016	90.029999	118.279228	43.602196	2065.30005
5/1/2016	102.57	114.136803	41.520313	2096.94995
6/1/2016	91.480003	112.528442	38.324192	2098.86011
7/1/2016	91.25	110.821709	36.26086	2173.6001
8/1/2016	97.449997	108.94722	36.133499	2170.94995
9/1/2016	98.550003	109.509125	38.206409	2168.27002
10/1/2016	124.870003	106.860626	39.346016	2126.1499
11/1/2016	117	113.22081	45.79071	2198.81006
12/1/2016	123.800003	116.445076	48.963936	2238.83008
1/1/2017	140.710007	117.25824	51.499931	2278.87012
2/1/2017	142.130005	122.118103	56.904907	2363.63989
3/1/2017	147.809998	124.905792	52.927471	2362.71997
4/1/2017	152.199997	134.851227	55.445705	2384.19995
5/1/2017	163.070007	145.413437	59.262405	2411.80005
6/1/2017	149.410004	147.601028	61.284164	2423.40991
7/1/2017	181.660004	150.446396	54.836327	2470.30005
8/1/2017	174.710007	155.13028	51.507229	2471.6499
9/1/2017	181.350006	152.841263	55.430038	2519.36011
10/1/2017	196.429993	162.820633	53.330864	2575.26001
11/1/2017	187.580002	167.756638	60.073963	2584.84009
12/1/2017	191.960007	168.903915	64.806999	2673.61011
1/1/2018	270.299988	167.94223	60.324856	2823.81006
2/1/2018	291.380005	154.792633	57.387993	2713.83008
3/1/2018	295.350006	154.428864	56.832367	2640.87012
4/1/2018	312.459991	165.350876	52.529617	2648.05005
5/1/2018	351.600006	158.01355	50.78957	2705.27002
6/1/2018	391.429993	154.735001	50.590706	2718.37012
7/1/2018	337.450012	156.562622	58.009007	2816.29004
8/1/2018	367.679993	161.223526	61.140858	2901.52002