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

QUESTION 7 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:-28%,6%,14%; MC: 8%,-1%,-30%. What is the sample variance 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 "1096" as .10", not as 0.10". You can use the VAR function in Excel.) QUESTION 8 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: 2% 28% 12%; MC: 36% 5%,23%. Calculate the correlation coefficient between the retur of FC and C. Enter your answer out to the fourth decimal, eg. ).0901". (For these problems don't enter the % into your formula, e.g. treat "1096" as "10", not as "0.10". You can use the =CORREL function in Excel ) QUESTION9 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:-3%,-8%,47% and MC:5%,-13%,-44%, lf FC and MC are combined in a portfolio with 50% of the funds invested in each, calculate the expected return on the portfolio. (For these problems don't enter the % into your formula, e.g treat "10%" as "10", not as "0.10. You may want to employ the-AVERAGE function in Excel.)