This is an individual Excel assignment. You must use Excel functions to answer ALL calculations. Each question/problem must be on a new Excel sheet. This means that you must use 10 Excel sheets for 10 questions/problems. Stock A and Stock B produced the following returns during the past five years: c. Calculate the standard deviation of returns for each stock and for the portfolio. d. Calculate the coefficient of variation for each stock and for the portfolio. If you are a ris averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? Why? This is an individual Excel assignment. You must use Excel functions to answer ALL calculations. Each question/problem must be on a new Excel sheet. This means that you must use 10 Excel sheets for 10 questions/problems. Stock A and Stock B produced the following returns during the past five years: c. Calculate the standard deviation of returns for each stock and for the portfolio. his is an individual Excel assignment You must use Excel functions to answer ALL calculations. Each question/problem must be on a new Excel sheet. This means that you must use 10 Excel sheets for 10 questions/problems. Stock A and Stock B produced the following returns during the past five years: a. Calculate the average rate of return for each stock during the period 2018-2022. b. Assume that someone held a portfolio consisting of 50 percent Stock A and 50 percent Stock B. What would have been the realized rate of return on the portfolio in each year from 2018 through 2022? What would have been the average return on the portfolio during this period? c. Calculate the standard deviation of returns for each stock and for the portfolio. d. Calculate the coefficient of variation for each stock and for the portfolio. If you are a ris averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? Why? This is an individual Excel assignment. You must use Excel functions to answer ALL calculations. Each question/problem must be on a new Excel sheet. This means that you must use 10 Excel sheets for 10 questions/problems. Stock A and Stock B produced the following returns during the past five years: c. Calculate the standard deviation of returns for each stock and for the portfolio. d. Calculate the coefficient of variation for each stock and for the portfolio. If you are a ris averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? Why? This is an individual Excel assignment. You must use Excel functions to answer ALL calculations. Each question/problem must be on a new Excel sheet. This means that you must use 10 Excel sheets for 10 questions/problems. Stock A and Stock B produced the following returns during the past five years: c. Calculate the standard deviation of returns for each stock and for the portfolio. his is an individual Excel assignment You must use Excel functions to answer ALL calculations. Each question/problem must be on a new Excel sheet. This means that you must use 10 Excel sheets for 10 questions/problems. Stock A and Stock B produced the following returns during the past five years: a. Calculate the average rate of return for each stock during the period 2018-2022. b. Assume that someone held a portfolio consisting of 50 percent Stock A and 50 percent Stock B. What would have been the realized rate of return on the portfolio in each year from 2018 through 2022? What would have been the average return on the portfolio during this period? c. Calculate the standard deviation of returns for each stock and for the portfolio. d. Calculate the coefficient of variation for each stock and for the portfolio. If you are a ris averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? Why