dear expert this question belong to the subject of security and risk portfolio please give me all requirement answer. this all 6 requirement related to this question so please dont give me a incomplete answer.. give me proper valid answer in a word format.. thanks

please provide answer in a format if u r using excel please show all calculation and give answer into a word foam

Q2) You are working as a portfolio associate and your manager assigned task to find out which investment option is feasible for existing portfolio. All of the investment options are riskier than market however still manager wants to optimize its risk in given investment options. Years Market A B D 1 39,400.00 70.00 15.00 10.00 51.50 2 39,800.00 71.00 15.00 10.50 51.80 3 39,900.00 71.80 16.00 11.20 51.40 4 40,110.00 71.50 17.00 10.80 52.00 5 40,500.00 72.00 16.00 10.50 52.50 6 40,400.00 72.15 16.00 10.90 53.00 7 40,500.00 72.80 16.00 11.10 52.40 8 40,200.00 71.50 16.00 11.20 52.10 9 40,150.00 71.30 15.00 10.80 53.50 10 40,500.00 71.90 17.00 11.00 53.20 Requirements: 1. Calculate Average of each of the investment option. 2. Calculate the Risk of each of the investment option. 3. Calculate the Co-efficient of Variation of each investment option. 4. Calculation of correlation each of the investment option. 5. Calculate Beta of each of the investment option. 6. Give your conclusion or recommendation which investment option is best for you in comparison to least risky Q2) You are working as a portfolio associate and your manager assigned task to find out which investment option is feasible for existing portfolio. All of the investment options are riskier than market however still manager wants to optimize its risk in given investment options. Years Market A B D 1 39,400.00 70.00 15.00 10.00 51.50 2 39,800.00 71.00 15.00 10.50 51.80 3 39,900.00 71.80 16.00 11.20 51.40 4 40,110.00 71.50 17.00 10.80 52.00 5 40,500.00 72.00 16.00 10.50 52.50 6 40,400.00 72.15 16.00 10.90 53.00 7 40,500.00 72.80 16.00 11.10 52.40 8 40,200.00 71.50 16.00 11.20 52.10 9 40,150.00 71.30 15.00 10.80 53.50 10 40,500.00 71.90 17.00 11.00 53.20 Requirements: 1. Calculate Average of each of the investment option. 2. Calculate the Risk of each of the investment option. 3. Calculate the Co-efficient of Variation of each investment option. 4. Calculation of correlation each of the investment option. 5. Calculate Beta of each of the investment option. 6. Give your conclusion or recommendation which investment option is best for you in comparison to least risky