Document 2- Measuring Risk and Return For the next four questions (Q2a-d), you will need the data found in the spreadsheet RISK 2 Please show all of your work 1) Calculate the average monthly return...

please find the instructions in the word file. Thank you


Document 2- Measuring Risk and Return For the next four questions (Q2a-d), you will need the data found in the spreadsheet RISK 2 Please show all of your work 1) Calculate the average monthly return of the data series in the excel file (use AVERAGE function). Put your answer from cell C40 in the box below. Show work 2) Calculate the average annual return of the data series in the excel file. Put your answer from cell C41 in the box below. Show work 3) Calculate the monthly volatility of the data series in the excel file (use STDEV.S function). Put your answer from cell C42 in the box below. Show work 4) Calculate the annual volatility of the data series in the excel file. Put your answer from cell C43 in the box below. Show work