Question: Hey, please show me how to use Excel to do these problems ! QUESTION 1 5 points Save Answer Florida Company (FC) and Minnesota Company
Hey, please show me how to use Excel to do these problems !

QUESTION 1 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:-10%,15%, 25%; MC:-19%, 18%, 26%. Calculate the sample variance of return for MC.(For these problems don't enter the % into your formula, eg. treat "1096" as "10", not as "O.10. You can use the -VAR function in Excel) QUESTION 2 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:-10%, 15%, 25%; MC:-696,-14%,-10%. Calculate the sample standard deviation of return for MC. (For these problems don't enter the % into your formula, eg. treat "10%" as "10", not as "0.10". You can use the STDEV function in Excel.) QUESTION 3 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: 19%-32%,7%; MC: 10%, 6%, 32%. Calculate the sample variance of return for FC. (For these problems don't enter the % into your formula, eg. treat "10%" as "10", not as .0.10.. You can use the VAR function in Excel.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
