Step 2: Calculate the 90-day correlation of Apple and S&P 500 by using the shorthand command in the spreadsheet. It won't matter whether Apple is the first or second array, just as long as the ...

Correlation is measured through the correlation coefficient, which always returns a value between +1.0 (perfectly positively correlated) and -1.0 (perfectly negatively correlated).

Investopedia / Hugo Lin Assessments of correlation strength based on the correlation coefficient value vary by application. In physics and chemistry, a correlation coefficient should be lower than ...