The Dow.xlsx file contains the monthly returns of the 30 stocks that make up the Dow Jones

Question:

The Dow.xlsx file contains the monthly returns of the 30 stocks that make up the Dow Jones Industrial Average. Find the correlations between each pair of stocks. Then, for each stock, use conditional formatting to highlight the three stocks most correlated with that stock. (Of course, you should not highlight a stock as correlated with itself.)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: