Question: how to calculate the correlation matrix in excel?
Answer: Step 1: On the top right corner of the data tab click data analysis.
Step 2: Select Correlation and click ok.
Step 3: Click in the Input Range box and select the range A1:C10, select the “Labels in first row” tick box and output range, as shown below and click ok.