Data = https://docs.google.com/spreadsheets/d/1lwb8nHYAQ8jk4nMKituigJRPRSkIlGJ1bEr68s8sWpo/edit#gid=0

The questions can be solved through excel but you will have to copy the data from this excel to another.

Question 4: What is the annualized market volatility? (Assume 252 trading days in a year) Q A. 9.23% O B. 9.43% O c. 9.63% O D. 9.83% Y Click to see additional instructions Question 5: What is the annualized average excess return for NFLX? (Assume 252 trading days in a year) (Answer in %, round answer to two decimal places) Question 5: What is the annualized Sharpe ratio for NFLX? (Assume 252 trading days in a year) (Round answer to two decimal places) Answen E Question 7: What is the annualized volatility with the portfolio that included all 9 stocks? (Assume 252 trading days in a year) (Answer in %, round answer to two decimal places) m :93 Question 8: What is the annualized Sharpe ratio with the portfolio that inducted all 9 stocks? (Assume 252 trading days in a year) {Round answer to two decimal places) W E Question 9: Judging from the trend on Sharpe ratio, do you think you would likely get a higher or lower Sharpe ratio if you add more stocks to your portfolio? OA. Higher Sharpe ratio O B. Lower Sharpe ratio