Question: how to calculate correlation between two sets of data in excel?
Answer: On the Data tab, in the Analysis group, click Data Analysis. ...  Select Correlation and click OK. For example, select the range A1:C6 as the Input Range.