I need to get solution of question 33.

Assignment 3 FINA 409 Fall 2021 Due Friday November 19th by midnight Directions: This assignment is to be completed in groups of two. Please submit your answers in the form of an Excel file to Blackboard. Each question/exercise should be completed on a separate tab in your Excel file. Please highlight your answers and include formulas (including a formulatext cell next to your final answers) in your spreadsheet. Failure to include formulas (i.e., answers are hardcoded) will result in a grade of zero for that question. Make sure to include names in your Excel file. For the exercises from Chapter 33, 8, and 11 - download the most recent 5 years of monthly stock prices from Yahoo! for the following twelve companies: JPM, BAC, WFC, PNC, XOM, CVX, COP, OXY, BA, GD, NOC, and LMT. Also, download 5 years of prices for the S&P 500 (SPY). Use the adjusted closing prices to compute monthly returns for the twelve companies and the S&P 500. Chapter 33: 1) Compute the Beta for JPM using a scatter plot and trendline. 2) Compute Beta for XOM using the Data Analysis function in Excel. What was XOM's 'Alpha' during the past 5 years? Are Alpha or Beta statistically significant? 3) Which stock (out of all twelve) had the greatest number of negative monthly returns during the past 5 years? Which stock had the greatest number of positive monthly returns during the past 5 years? 4) Which stock had the highest single monthly return? Which stock had the lowest single monthly return? 5) Which stock had the lowest Beta (you can use the slope function)? Which stock had the highest correlation with the S&P 500? Assignment 3 FINA 409 Fall 2021 Due Friday November 19th by midnight Directions: This assignment is to be completed in groups of two. Please submit your answers in the form of an Excel file to Blackboard. Each question/exercise should be completed on a separate tab in your Excel file. Please highlight your answers and include formulas (including a formulatext cell next to your final answers) in your spreadsheet. Failure to include formulas (i.e., answers are hardcoded) will result in a grade of zero for that question. Make sure to include names in your Excel file. For the exercises from Chapter 33, 8, and 11 - download the most recent 5 years of monthly stock prices from Yahoo! for the following twelve companies: JPM, BAC, WFC, PNC, XOM, CVX, COP, OXY, BA, GD, NOC, and LMT. Also, download 5 years of prices for the S&P 500 (SPY). Use the adjusted closing prices to compute monthly returns for the twelve companies and the S&P 500. Chapter 33: 1) Compute the Beta for JPM using a scatter plot and trendline. 2) Compute Beta for XOM using the Data Analysis function in Excel. What was XOM's 'Alpha' during the past 5 years? Are Alpha or Beta statistically significant? 3) Which stock (out of all twelve) had the greatest number of negative monthly returns during the past 5 years? Which stock had the greatest number of positive monthly returns during the past 5 years? 4) Which stock had the highest single monthly return? Which stock had the lowest single monthly return? 5) Which stock had the lowest Beta (you can use the slope function)? Which stock had the highest correlation with the S&P 500