Problem 2: For Delta and Southwest Airline stocks (DAL & LUV), find monthly holding-period returns from June 2014 through May 2015 and compare to the S&P 500 Index. Answer the questions below. DAL Luv S&P 500 Month and Year Price Return (%) Price Return (%) Return (%) 2014 May June July August September October November December 2015 January February March April May Average Monthly Return Standard Deviation (a) Which stock is risky relative to each other? (b) Which stock is more risky relative to the S&P Index? (c) Plot the returns of the most risky stock relative to the S&P 500 and determine the beta coefficient using the spreadsheet found on Canvas. ... AutoSave OFF Svo Beta_linear_regression_example Data Review > Home Insert Draw Page Layout Formulas Share Comments . Au Conditional Formatting Format as Table Cell Styles Paste Font Alignment Number Cells Editing Ideas A54 fx C D E F G H I J K L M x A B 1 ABC 2 Month Sales 3100 4500 5 3 4400 5400 7500 6 8100 Formula Descriptio Result 00 #VALUE! 11000 Estimate sales for the ninth month ..1 T-Mobile 3:04 PM Home Insert Draw Page Layout Formulas Share Comments . Au Conditional Formatting Format as Table Cell Styles Paste Font Alignment Number Cells Editing Ideas A54 fx C D E F G H I J K L M x A B 1 ABC 2 Month Sales 3100 4500 5 3 4400 5400 7500 6 8100 Formula Descriptio Result 00 #VALUE! 11000 Estimate sales for the ninth month ..1 T-Mobile 3:04 PM