Question
In: Finance
The table below is the Monthly return Correlation Coefficients between two stocks: RIO & ANZ 0.6162...
The table below is the Monthly return Correlation Coefficients between two stocks:
| RIO & ANZ | 0.6162 |
| RIO & WES | 0.7593 |
| RIO & TLS | -0.6850 |
| ANZ & WES | 0.5970 |
| ANZ & TLS | -0.1865 |
| WES & TLS | -0.5192 |
Required:
a. Which pair of two stocks have the highest and lowest correlations?
b. Suggest some economic reasons to explain the high and low correlation between these stocks. If you were to form a portfolio of two stocks, which ones would you choose to maximise the benefits of diversification? Give reasons for your answer.
Solutions
Expert Solution
a) The stock pair RIO & TLS have the lowest correlation since they have the most negative value for correlation out of all, while the stock pair RIO & WES have the highest correlation since they have the highest positive value of correlation out of all.
b)
to maximize the benefits of diversification , we should choose stocks with the lowest correlation , i.e. the stock pair RIO &TLS, since a negative correlation between stocks will lead to a lower standard deviation / risk of the portfolio than the individual risk for the stocks.
A change in economy / market trend affects stocks differently , similar types of companies are affected by a market trend more or less in the same way and hence usually have a higher correlation between them.
A change in market for companies in a different line of business usually will not be affected at the same degree and hence the correlation between such stocks will be lower.
jeff jeffy answered 5 months agoRelated Solutions
The table below shows standard deviations and correlation coefficients for seven stocks from different countries. Calculate...
The table below shows standard deviations and correlation
coefficients for seven stocks from different countries. Calculate
the variance of a portfolio with equal investments in each stock.
(Use decimals, not percents, in your calculations. Do not
round intermediate calculations. Round your answer to 4 decimal
places.)
Portfolio Varience:?
BHP Billiton
Siemens
Nestlé
LVMH
Toronto Dominion Bank
Samsung
BP
BHP Billiton
1.00
0.28
0.37
0.40
0.16
0.40
0.14
Siemens
1.00
0.34
0.16
0.14
0.31
–0.12
Nestlé
1.00
0.09
0.10
0.02
0.10...
The table below shows standard deviations and correlation coefficients for eight stocks from different countries. Calculate...
The table below shows standard deviations and correlation
coefficients for eight stocks from different countries. Calculate
the variance of a portfolio with equal investments in each stock.
(Use decimals, not percents, in your calculations. Do not
round intermediate calculations. Round your answer to 5 decimal
places.)
BHP
BP
Fiat
Chrysler
Heineken
Korea
Electric
Nestlè
Sony
Tata Motors
BHP
1.00
.34
.38
.45
.14
.45
.16
.29
BP
.34
1.00
.29
.14
.16
.36
−.07
.12
Fiat
.38
.29
1.00
−.03...
The table below shows standard deviations and correlation coefficients for eight stocks from different countries. Calculate...
The table below shows standard deviations and correlation
coefficients for eight stocks from different countries. Calculate
the variance of a portfolio with equal investments in each stock.
(Use decimals, not percents, in your calculations. Do not
round intermediate calculations. Round your answer to 5 decimal
places.)
BHP
BP
Fiat
Chrysler
Heineken
Korea
Electric
Nestlè
Sony
Tata Motors
BHP
1.00
.26
.42
.40
.17
.40
.12
.34
BP
.26
1.00
.34
.17
.12
.33
.49
.17
Fiat
.42
.34
1.00
.09...
Using excel compute correlation coefficients, correlation matrix and test the significance of the correlation coefficients between...
Using excel compute correlation coefficients, correlation matrix
and test the significance of the correlation coefficients between
sales with price, sales with advertisments using alpha
0.05
Sales
Price
Adver
19.98
14.10
15.19
19.98
18.65
15.19
19.98
18.65
13.87
19.98
18.65
12.83
19.98
18.65
13.16
19.98
18.65
15.19
19.98
18.65
13.92
20.10
18.73
14.42
20.12
18.75
13.83
20.13
18.75
14.50
20.14
18.75
13.87
20.12
18.75
13.64
20.12
13.87
14.31
20.13
14.27
13.85
20.14
18.76
14.20
20.14
18.77
13.64
20.13
13.87
14.33
20.13
14.14...
Calculate the covariance and correlation coefficients by completing the below table, assuming sample data. Show all...
Calculate the covariance and correlation coefficients by
completing the below table, assuming sample data. Show all
workings. (Note: You can calculate the mean and standard deviation
of X & Y with Excel or your calculator; no working for their
calculation is required.)
X
Y
(X - X bar)
(Y - Y bar)
(X - X bar)(Y - Y bar)
5
5
2
3
5
4
8
7
6
9
(b) Comment on the
direction and strength of the association between X...
The table below gives statistics relating to two stocks. Mean Annual Return (%) Standard Deviation of...
The table below gives statistics relating to two stocks.
Mean Annual Return (%)
Standard Deviation of Return (%)
Skewness
Excess
Kurtosis
Stock A
11.5
5.5
-0.45
-0.5
Stock B
12.0
8.5
0.25
2.5
Based on the information in the table, contrast the distribution
of returns of Stock A and B. Evaluate the relative attractiveness
of Stock A and B
true or false 16. If the correlation coefficent between two stocks is 1, then an investor...
true or false
16. If the correlation coefficent between two stocks is 1, then
an investor can signifcantly reduce risk by holding the two stocks
in a portfolio.
18. Investors can reduce risk by holding more than one asset in
a portfolio.
19. A nominal rate could best be described as
the rate that tells you what you really earn on an annual
basis
The rate that you use in calculations
Its hard to say exactly
The stated rate that...
Diversification is the most effectivewhen the correlation coefficient between two assets’ return is _________ . A)...
Diversification is the most
effectivewhen the correlation coefficient between two assets’
return is _________ .
A)
positive
B)
negative
C)
+1
D) 0
E)
-1
Based on investors’ relative degrees
of risk aversion,
A)
investors will hold varying amounts of the risky asset in their
portfolios.
B) all
investors will have the same portfolio asset allocations.
C)
investors will hold varying amounts of the risk-free asset in their
portfolios.
D) A and
C.
E) none
of the above.
Use the data values in the table below to calculate the correlation, r, between the variables...
Use the data values in the table below to calculate the
correlation, r, between the variables x and y.
x
y
4
12.32
5
13.1
6
16.68
7
20.26
8
22.44
9
22.72
10
23.4
11
26.98
12
28.66
Give your answer to rounded three decimal places.
Calculate the correlation of the two stocks below based on the scenario forecasts given: Probability Atlantis...
Calculate the correlation of the two stocks below based on the
scenario forecasts given:
Probability
Atlantis Co.
Baltazaar Inc.
Boom
0.3
9
14%
Normal
0.6
13
4%
Bust
0.1
-10%
-6%
Provide your answer in decimals, rounded to two decimals.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Suppose you observe the following situation: State of Economy Probability of State Return if State Occurs...
- Merger Analysis TransWorld Communications Inc., a large telecommunications company, is evaluating the possible acquisition of Georgia...
- Journal Entries and Trial Balance Elite Realty acts as an agent in buying, selling, renting, and...
- In racket Assume that the elements of a list are indexed starting with 1. Write a...
- Describe System Development Life Cycle (SDLC) and how it is used.
- What symbolism do you find in the play,Oedipus?
- • Using the Scanner class to obtain input from the user. • Using printf to output...
ADVERTISEMENT