Calculate the correlation coefficient between every possible pair of securities’ annual rates of return. Microsoft Historical Annual Stock Price DataYearAverage Stock PriceYear OpenYear HighYear LowYear CloseAnnual % Change2021261.8771217.6900308.2300212.2500308.230038.58%2020193.0261160.6200231.6500135.4200222.420041.04%2019130.3820101.1200158.960097.4000157.700055.26%2018101.034085.9500115.610085.0100101.570018.74%201771.984062.580086.850062.300085.540037.66%201655.259354.800063.620048.430062.140012.00%201546.713646.760056.550040.290055.480019.44%201442.453337.160049.610034.980046.450024.16%201332.491527.620038.940026.460037.410040.06%201229.820326.765032.850026.370026.70972.89%201126.052227.980028.870023.705025.9600-6.99%201027.058430.950031.390023.010027.9100-8.43%200922.976620.330031.390015.150030.480056.79%200826.647535.220035.370017.530019.4400-45.39%200730.445929.860037.060026.720035.600019.22%200626.290826.840030.190021.510029.860014.19%200525.871026.740028.160023.920026.1500-2.13%200427.124727.450029.980024.150026.7200-2.37%200326.101426.860029.960022.800027.37005.88%200227.274533.520034.930021.415025.8500-21.96%200131.271221.690036.840021.690033.125052.72%

The correlation coefficient between the annual rates of return and Annual stock prices can be…

Answered: Calculate the correlation coefficient…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Microsoft Historical Annual Stock Price Data
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%

Similar questions

Stock prices: Following are closing prices for a certain stock during June and July of a certain year. June July 474.02 487.01 488.50 483.19 497.99 456.56 467.49 475.83 489.20 491.34 488.56 486.25 482.05 472.68 472.08 494.02 459.61 466.18 481.59 477,50 454.26 444.95 482.37 493.37 498.72 484.81 490.06 488.97 492.63 484.35 Send data to Excel Part 1 of 2 (e) Find the population standard deviation and variance for the prices in June. Round the answers to at least three decimal places The population standard deviation for the prices in June is The population variance for the prices in June is Part 2 of 2 (b) Find the population standard deviation and variance for the prices in July. Round the answers to at least three decimal places The population standard deviation for the prices in July is
Alertbdont submit AI generated answer.
Stock prices: Following are closing prices for a certain stock during June and July of a certain year. June July 472.68 472.08 454.26 444.95 482.37 491.34 494.02 459.61 466.18 481.59 493.37 498.72 485.52 484.78 474.02 477.50 484.81 490.06 488.97 492.63 487.01 488.50 483.19 497.99 488.56 484.35 484.99 484.85 439.49 436.55 Send data to Excel Part 1 of 2 (a) Find the population standard deviation and variance for the prices in June. RoUnd the answers to at least three deci places. The population standard deviation for the prices in June is The population variance for the prices in June is
Stock prices: Following are closing prices for a certain stock during June and July of a certain year. June July 472.68 472.08 454.26 444.95 482.37 491.34 494.02 459.61 466.18 481.59 493.37 498.72 485.52 484.78 474.02 477.50 484.81 490.06 488.97 492.63 487.01 488.50 483.19 497.99 488.56 484.35 484.99 484.85 439.49 436.55 Send data to Excel Part 1 of 2 (a) Find the population standard deviation and variance for the prices in June. Round the answers to at least three decimal places. The population standard deviation for the prices in June is The population variance for the prices in June is
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
A proposed project has the following cash flow estimates.Assuming statistically independent cash flows, a normally distributed net present value, and a minimum attractive rate of return of 15%, determine the following. For the following questions, employ an analytical solution: a. the mean and standard deviation of net present value. b. the probability that the net present value is negative. c. the probability that the net present value is greater than $1,000,000. Assume the initial investment and annual receipts are normally distributed. d. Using a Monte Carlo simulation with 10,000 iterations, estimate the probability that the present worth is negative.
Consider the following table containing yields for mutual funds in different asset classes (small, mid, and large cap). Small Cap Fund Explorer Value Small-Cap Value Index Admiral Small-Cap Index Admiral Shares Strategic Small-Cap Equity Explorer Small-Cap Growth Index Admiral Explorer Value Small-Cap ETF Yield (%) 2.93 2.46 1.49 2.91 0.17 0.21 2.67 1.44 Fund Yield by Asset Class Mid Cap Fund Capital Value Mid-Cap Value Index Admiral Extended Market Index Admiral Shares Mid-Cap Index Admiral Shares Mid-Cap Growth Capital Value Strategic Equity Capital Opportunity Admiral Shares Yield (%) 0.96 2.73 1.22 1.52 1.9 0.32 1.54 1.44 sum of squares for treatments≈ 0.6898 sum of squares for error 22.3436 Step 1 of 2: What are the degrees of freedom for the sum of squares for error? Large Cap Fund Equity Income High Dividend Yield Index 500 Index Admiral Shares Diversified Equity FTSE Social Index Growth Equity U.S. Growth Windsor Yield (%) 3.24 3.50 2.73 1.23 1.42 0.58 0.37 1.64
The following table lists several corporate bonds issued during the second quarter of 2015. Company AT&T Bank of America General Electric Goldman Sachs Verizon Wells Fargo Time to Maturity (years) 10 10 2 8 7 Annual 3.40 4.00 5.25 6.15 5.15 3.50 Rate (%) If you spent $30,000 on AT&T bonds, how much interest would you earn every 6 months? HINT [See Example 3.] $ How much interest would you earn over the life of the bonds?
The following table lists several corporate bonds issued during the second quarter of 2015. Company AT&T Bank of America General Electric Goldman Sachs Verizon Wells Fargo Time to Maturity (years) 10 10 3 8 7 Annual 3.40 4.00 5.25 6.15 5.15 3.50 Rate (%) If you spent $20,000 on AT&T bonds, how much interest would you earn every 6 months? HINT [See Example 3.] $ How much interest would you earn over the life of the bonds? $ %24

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

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

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

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

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

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

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS

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%

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%