Use the CORREL function in Excel to calculate this value ... assume returns are normally distributed. Normal distribution, known as the bell curve, assumes more results clustered near the center ...