Calculate the following data from 1-15 according to the attached excel image Please enlarge the image for illustration All data are complete I want a solution as soon as possible please Question number must be deep and very good answer

1- Find the average daily market return (return for Al-Quds index)

2- Find the average daily return for BoP

3- Find the average daily return for PALTEL

4- Find the expected daily return for PEC

5- Find the standard deviation for OOREDOO

6- Find the standard deviation for PADICO

7- Find the coefficient of variation for AIG (calculate it as r/sd)

8- Find the coefficient of variation for APIC (using the formula r/sd)

9- Based on the SD, rank the following stocks from the least risky to the highest risk-The second rank in the highest risk-Lowest Risk-Lowest Risk

10 Find Beta for APIC

11- Find beta for PALTEL

12- Rank the stocks from the highest to the lowest beta-The second rank in the lowest beta-Highest Beta-Lowest Beta-The second rank in highest beta

13-Explain the differences in ranking stocks according to the standard deviation (SD) and beta. This should entail explaining the different aspects that SD and beta measure, and why a stock that has the highest standard deviation might not have the highest beta.

14-Based on CAPM, and assuming a risk-free rate of 2% and a market return of 5.8%, what is the required return for PEC?

15-Using CAPM, and assuming a risk-free rate of 2% and a market return of 5.8%, what is the required return for PALTEL?

X Microsoft Excel DSS1 3.7 1.79 0.9 3.75 3.77 3.77 3.78 3.8 3.8 3.8 1.4 1.41 1.4 B 473.62 475.88 476.3 478.89 476.17 475.21 474.77 473.91 474.55 473.77 472.14 472.9 472.56 473.95 563 2020/6/1 564 2020/6/2 565 2020/6/3 566 2020/6/4 567 2020/6/7 568 2020/6/8 569 2020/6/9 570 2020/6/10 571 2020/6/11 572 2020/6/14 573 2020/6/15 574 2020/6/16 575 2020/6/17 576 2020/6/18 577 578 579 1.79 1.85 1.83 1.83 1.84 1.82 1.82 1.82 1.81 1.81 1.8 0.84 0.82 0.84 0.84 0.82 0.83 0.82 0.83 0.83 0.81 0.81 0.81 0.83 0.83 H 0.28 0.28 0.28 0.29 0.29 0.29 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 2.45 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.45 2.46 2.46 2.46 0.89 0.87 0.87 0.84 0.85 0.86 0.84 0.85 0.85 0.86 1.4 1.4 3.8 3.8 3.79 1.4 1.39 X Microsoft Excel DSS1 3.7 1.79 0.9 3.75 3.77 3.77 3.78 3.8 3.8 3.8 1.4 1.41 1.4 B 473.62 475.88 476.3 478.89 476.17 475.21 474.77 473.91 474.55 473.77 472.14 472.9 472.56 473.95 563 2020/6/1 564 2020/6/2 565 2020/6/3 566 2020/6/4 567 2020/6/7 568 2020/6/8 569 2020/6/9 570 2020/6/10 571 2020/6/11 572 2020/6/14 573 2020/6/15 574 2020/6/16 575 2020/6/17 576 2020/6/18 577 578 579 1.79 1.85 1.83 1.83 1.84 1.82 1.82 1.82 1.81 1.81 1.8 0.84 0.82 0.84 0.84 0.82 0.83 0.82 0.83 0.83 0.81 0.81 0.81 0.83 0.83 H 0.28 0.28 0.28 0.29 0.29 0.29 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 2.45 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.45 2.46 2.46 2.46 0.89 0.87 0.87 0.84 0.85 0.86 0.84 0.85 0.85 0.86 1.4 1.4 3.8 3.8 3.79 1.4 1.39