Question: need help on how to set up this on excel please ! QUESTION 4 5 pointsSave Answer Florida Company (FC) and Minnesota Company (MC) are

need help on how to set up this on excel please !need help on how to set up this on excel please !

QUESTION 4 5 pointsSave Answer Florida Company (FC) and Minnesota Company (MC) are both service companies. Their historical return for the past three years are: FC: 33%,30%,-42%; 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 "O.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:-23%,-2%,-28%; MC: 5%,-16%, 2%. Calculate the sample covariance between the returns of FC and MC. (For these problems don't enter the % into your formula, eg. treat "10%" as "10", not as 10.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: 32%,20%,37%; MC:-696,-8%,-40%. 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 96 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!