![subject](/tpl/images/cats/mat.png)
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](/tpl/images/cats/User.png)
Answers: 3
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Another question on Mathematics
![question](/tpl/images/cats/mat.png)
Mathematics, 21.06.2019 17:00
When only separate discreet points are graphed it is called?
Answers: 1
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 22.06.2019 00:30
Jennifer taking a quiz and has answered 13 questions so far. if there are 25 questions on jennifer test, how many questions does she have left to answer
Answers: 1
![question](/tpl/images/cats/mat.png)
Mathematics, 22.06.2019 01:00
Arestaurant offers delivery for their pizzas. the total cost the customer pays is the price of the pizzas, plus a delivery fee. one customer pays $23 to have 2 pizzas delivered. another customer pays $59 for 6 pizzas. how many pizzas are delivered to a customer who pays $86?
Answers: 1
You know the right answer?
The "Investments" worksheet contains information on 5
investments. At the top of column B (B2:B6) a...
Questions
![question](/tpl/images/cats/mat.png)
Mathematics, 01.08.2019 23:50
![question](/tpl/images/cats/istoriya.png)
History, 01.08.2019 23:50
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/ap.png)
Advanced Placement (AP), 01.08.2019 23:50
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/fizika.png)
Physics, 01.08.2019 23:50
![question](/tpl/images/cats/obshestvoznanie.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 01.08.2019 23:50
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/istoriya.png)
History, 01.08.2019 23:50
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/es.png)
Spanish, 01.08.2019 23:50
![question](/tpl/images/cats/mat.png)
Mathematics, 01.08.2019 23:50