Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedneed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance Without Fear Business Forecasting Workbook

Authors: William S. Hettinger, John Dolan Heitlinger

1st Edition

0982891717, 9780982891711

More Books

Students also viewed these Finance questions

Question

Help.

Answered: 1 week ago

Question

Find the derivative of y= cos cos (x + 2x)

Answered: 1 week ago