A B 1 Market Capitalization, in millions YUM ZTS ΑAPL Market (OEX) 31/01/18 28506.29 37389.63 369899.4 15851230 4 5 Monthly prices Dates YUM ZTS AAPL Market (OEX) 7 31/01/18 84.59 76.73 87.3 1251.42 8. 28/02/18 81.38 80.86 75.74 1201.87 9. 30/03/18 85.13 83.51 74.61 1157.37 10 30/04/18 87.1 83.48 77.75 1160.73 2 11 31/05/18 81.33 83.7 81.24 1188.91 3 12 29/06/18 78.22 85.19 82.73 1194.5 4 13 31/07/18 79.29 86.48 81.51 1241.76 14 31/08/18 86.89 90.6 80.17 1286.9 6 7 15 28/09/18 90.91 91.56 85.02 1294.27 8 Please show full working 9. a. What is the correlation between eạch of the stocks and the market (show in a correlation matrix)
A B 1 Market Capitalization, in millions YUM ZTS ΑAPL Market (OEX) 31/01/18 28506.29 37389.63 369899.4 15851230 4 5 Monthly prices Dates YUM ZTS AAPL Market (OEX) 7 31/01/18 84.59 76.73 87.3 1251.42 8. 28/02/18 81.38 80.86 75.74 1201.87 9. 30/03/18 85.13 83.51 74.61 1157.37 10 30/04/18 87.1 83.48 77.75 1160.73 2 11 31/05/18 81.33 83.7 81.24 1188.91 3 12 29/06/18 78.22 85.19 82.73 1194.5 4 13 31/07/18 79.29 86.48 81.51 1241.76 14 31/08/18 86.89 90.6 80.17 1286.9 6 7 15 28/09/18 90.91 91.56 85.02 1294.27 8 Please show full working 9. a. What is the correlation between eạch of the stocks and the market (show in a correlation matrix)
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
![A
E
2
1 Market Capitalization, in millions
3
2
YUM
ZTS
ΑAPL
Market (OEX)
4
3
31/01/18 28506.29 37389.63 369899.4
15851230
4
6
5 Monthly prices
7
Dates
YUM
ZTS
АAPL
Market (OEX)
8
31/01/18
28/02/18
7
84.59
76.73
87.3
1251.42
81.38
80.86
75.74
1201.87
10
9.
11
30/03/18
85.13
83.51
74.61
1157.37
10
30/04/18
87.1
83.48
77.75
1160.73
12
11
13
31/05/18
81.33
83.7
81.24
1188.91
12
29/06/18
78.22
85.19
82.73
1194.5
14
13
31/07/18
79.29
86.48
81.51
1241.76
15
14
16
31/08/18
86.89
90.6
80.17
1286.9
15
28/09/18
90.91
91.56
85.02
1294.27
17
18 Please show full working
19
а.
What is the correlation between each of the stocks and the market (show in a correlation matrix)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F41351bd6-3cd6-4f3a-b770-45f5428ed8c5%2F4df7fe5f-e596-47c3-8566-3802b0b1a4db%2Fmcafk8p_processed.png&w=3840&q=75)
Transcribed Image Text:A
E
2
1 Market Capitalization, in millions
3
2
YUM
ZTS
ΑAPL
Market (OEX)
4
3
31/01/18 28506.29 37389.63 369899.4
15851230
4
6
5 Monthly prices
7
Dates
YUM
ZTS
АAPL
Market (OEX)
8
31/01/18
28/02/18
7
84.59
76.73
87.3
1251.42
81.38
80.86
75.74
1201.87
10
9.
11
30/03/18
85.13
83.51
74.61
1157.37
10
30/04/18
87.1
83.48
77.75
1160.73
12
11
13
31/05/18
81.33
83.7
81.24
1188.91
12
29/06/18
78.22
85.19
82.73
1194.5
14
13
31/07/18
79.29
86.48
81.51
1241.76
15
14
16
31/08/18
86.89
90.6
80.17
1286.9
15
28/09/18
90.91
91.56
85.02
1294.27
17
18 Please show full working
19
а.
What is the correlation between each of the stocks and the market (show in a correlation matrix)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education