Question: Please show me how to use excel to do these problems ! QUESTION 4 5 points Save Answer Florida Company (FC) and Minnesota Company (MC)

Please show me how to use excel to do these problems !
QUESTION 4 5 points Save Answer Florida Company (FC) and Minnesota Company (MC) are both service companies. Their historical return for the past three years are: FC:-15% ,-25%, 0%; MC: 10%, 6%, 32%. Calculate the sample standard deviation of return for FC. (For these problems don't enter the % into your formula, eg. treat "1096" as .10", not as 10.10". You can use the =STDEV function in Excel.) QUESTION 5 5 points Save Answer Florida Company (FC) and Minnesota Company (MC) are both service companies. Their historical return for the past three years are: FC:-7%,-10%,-30%; MC:-34%,-18%,-1996. Calculate the sample covariance between the returns of FC and MC.(For these problems don't enter the % into your formula, e.g. treat "10%" as "10", not as "0.10". If you use the -COVAR function in Excel you must multiply the result by (3/2) to adjust for the degrees of freedom.) QUESTION 6 5 points Save Answer Florida Company (FC) and Minnesota Company (MC) are both service companies. Their historical return for the past three years are: FC: 30%,-29%,-5%; MC:-4796,-26%,-896. What is the standard deviation of the portfolio with 50% of the funds invested in FC and 50% in MC? (For these problems don't enter the % into your formula, e.g. treat "10%" as "10", not as "0.10.. You can use the-VAR and-STDEV functions in Excel.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
