How to solve

Excel Online Structured Activity: Expected Returns: Discrete Distribution

The market and Stock J have the following probability distributions:

The data has been collected in the Microsoft Excel Online flle below. Open the spreadsheet and perform the required analysis to

answer the questlons below.

a$.$ Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two

dedimal places.

$\%$

Calculate the expected rate of return for Stock $3.$ Do not round intermedlate calculations. Round your answer to two decimal

places.

$\%$

b$.$ Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal

places.

$\%$

Calculate the standard deviation for Stock J$.$ Do not round intermediate calculations, Round your answer to two decimal

places.

Could you please include excel formulas to reach these answers when possible? Thank You!