please solve all requirement this question belong to security and risk portfolio please solve all requirement and please give me all calculations and answers in a table foam (dont give me image..)

please give me all work in word table foam acurately and properly

give me answer in a proper format

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 40,500.00 72.80 16.00 11.10 52.40 8 40,200.00 71.50 16.00 11.20 52.10 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 40,500.00 72.80 16.00 11.10 52.40 8 40,200.00 71.50 16.00 11.20 52.10 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