Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 !
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started