Hi there, could you please solve this in excel by showing what used in the formula bar? I don't how solve this.

The meaning of beta If a stock consitently goes down by 1.35% when the market portfolio goes down! 1.60% then what is the stock's beta? beta= Calculating the standard deviation of the market portfolio, given the standard deviation of a fully diversified portfolio and its beta What is the standard deviation of the of the market portfolio Sm if we know the standard deviation of a fully diversified portfolio Sp 20% and has a beta of 1.7 Standard deviation of the market portfolio