subject
Mathematics, 28.02.2021 17:00 luis759

The "Investments" worksheet contains information on 5 investments. At the top of column B (B2:B6) are the expected (average) returns of
the five stocks. Just to the side in column C (C2:C6) is the standard deviation of the
return of each investment. Column D (D2:D6) shows the amount of money invested
in each investment. The values in rows 10 through 14 are the correlation values that
quantify the pairwise relationships between the investments.

Investment data:

ABCDEF
1 Mean Annual ReturnStandard Deviation of Annual ReturnMoney Invested
2Investment 10.1640.059$7,700
3Investment 20.1720.071$6,500
4Investment 30.1220.028$7,700
5Investment 40.1100.083$5,400
6Investment 50.1500.110$6,000
7
8Correlation Matrix
9 Investment 1Investment 2Investment 3Investment 4Investment 5
10Investment 110.420.76-0.54-0.25
11Investment 20.4210.68-0.22-0.30
12Investment 30.760.681-0.83-0.58
13Investment 4-0.54-0.22-0.8310.57
14Investment 5-0.25-0.30-0.580.571
Question 1: A: What is the correlation between Investment 3 and Investment 4? Give your answer
to 2 decimal places.

Question 1: B: What is the covariance between Investment 3 and Investment 4? (Hint: use the
covariance formula.) Give your answer to 4 decimal places.

Question 1: C: Suppose that you created a portfolio of these 5 investments using the amounts of
money shown at the top of column D (D2:D6). What would the expected annual
return of the portfolio be? Give your answer to 3 decimal places.

Question 1: D: Using the portfolio of the previous question, what would the standard deviation of the
return of the portfolio be? Give your answer to 4 decimal places.

ansver
Answers: 3

Other questions on the subject: Mathematics

image
Mathematics, 21.06.2019 20:30, amauris77748
There are 45 questions on your math exam. you answered 810 of them correctly. how many questions did you answer correctly?
Answers: 3
image
Mathematics, 21.06.2019 21:00, india73
Due to financial difficulties the owner of 4 skateboard stores is going to close 2 of his stores. based on the money earned at each store, which two stores should remain open?
Answers: 2
image
Mathematics, 21.06.2019 21:50, shay68596
What is the next step in the given proof? choose the most logical approach. a. statement: m 1 + m 2 + 2(m 3) = 180° reason: angle addition b. statement: m 1 + m 3 = m 2 + m 3 reason: transitive property of equality c. statement: m 1 = m 2 reason: subtraction property of equality d. statement: m 1 + m 2 = m 2 + m 3 reason: substitution property of equality e. statement: 2(m 1) = m 2 + m 3 reason: substitution property of equality
Answers: 3
image
Mathematics, 21.06.2019 23:30, adelfaali99
Asinusoidal function whose frequency is 1/6pi
Answers: 2
You know the right answer?
The "Investments" worksheet contains information on 5 investments. At the top of column B (B2:B6) a...

Questions in other subjects: