Using the Excel function CORREL, calculate the correlation between the return on San Tome Mining and each of the other four stocks mentioned in problem 7 Which stock offers the best diversification benefit Problem 7 National Central Railway, 64 Million Minerva Shipping, 38 Million San Tome Sulaco M...

The correlation coefficients between the 4 annual rates of return on San Tome Mining STM and e ...

Using the Excel function CORREL, calculate the correlation between the return on San Tome Mining and each

Question:

Using the Excel function CORREL, calculate the correlation between the return on San Tome Mining and each of the other four mentioned in problem 7. Which stock offers the best diversification benefit?
Problem 7

National Central Railway, 64 Million Minerva Shipping, 38 Million San Tome Sulaco Market, 42 Million Mining, 184 Azuera,

Stocks
Stocks or shares are generally equity instruments that provide the largest source of raising funds in any public or private listed company's. The instruments are issued on a stock exchange from where a large number of general public who are willing...