Course Learning Assessment 2 CLO 1, CLO 3, CLO 4, CLO 5, CLO 6, CLO 7
This is a complete written report of your portfolio formation in a Word document. Your historical data and relevant derived values in tables can be pasted from your previous calculations in the Excel spreadsheet. Please provide explanations of all calculations and the justifications in Word format. Make sure to also paste all underlying Excel formulae that you used for calculations in the Word document.
Once again, provide the data that you presented in answering Part 2 of Professional Assignment 2.
Calculate the mean, variance, and the standard deviation of each securitys annual rate of return.
Calculate the correlation coefficient between every possible pair of securities annual rates of return.
Choose percentages of your initial investment that you want to allocate amongst the five (5) securities (weights in the portfolio).
