Calculate the correlation coefficient between every possible pair of securities’ annual rates of return.   Microsoft Historical Annual Stock Price Data Year Average Stock Price Year Open Year High Year Low Year Close Annual % Change 2021 261.8771 217.6900 308.2300 212.2500 308.2300 38.58%

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Calculate the correlation coefficient between every possible pair of securities’ annual rates of return.

 

Microsoft Historical Annual Stock Price Data
Year Average Stock Price Year Open Year High Year Low Year Close Annual % Change
2021 261.8771 217.6900 308.2300 212.2500 308.2300 38.58%
2020 193.0261 160.6200 231.6500 135.4200 222.4200 41.04%
2019 130.3820 101.1200 158.9600 97.4000 157.7000 55.26%
2018 101.0340 85.9500 115.6100 85.0100 101.5700 18.74%
2017 71.9840 62.5800 86.8500 62.3000 85.5400 37.66%
2016 55.2593 54.8000 63.6200 48.4300 62.1400 12.00%
2015 46.7136 46.7600 56.5500 40.2900 55.4800 19.44%
2014 42.4533 37.1600 49.6100 34.9800 46.4500 24.16%
2013 32.4915 27.6200 38.9400 26.4600 37.4100 40.06%
2012 29.8203 26.7650 32.8500 26.3700 26.7097 2.89%
2011 26.0522 27.9800 28.8700 23.7050 25.9600 -6.99%
2010 27.0584 30.9500 31.3900 23.0100 27.9100 -8.43%
2009 22.9766 20.3300 31.3900 15.1500 30.4800 56.79%
2008 26.6475 35.2200 35.3700 17.5300 19.4400 -45.39%
2007 30.4459 29.8600 37.0600 26.7200 35.6000 19.22%
2006 26.2908 26.8400 30.1900 21.5100 29.8600 14.19%
2005 25.8710 26.7400 28.1600 23.9200 26.1500 -2.13%
2004 27.1247 27.4500 29.9800 24.1500 26.7200 -2.37%
2003 26.1014 26.8600 29.9600 22.8000 27.3700 5.88%
2002 27.2745 33.5200 34.9300 21.4150 25.8500 -21.96%
2001 31.2712 21.6900 36.8400 21.6900 33.1250 52.72%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman