Use the CORREL function to calculate correlation coefficients
Syntax: CORREL(array1, array2)
Step 1: Define array1 and array2, which are the two data sets.
Step 2: Enter the formula in a cell and press Enter.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com