Question: how to calculate r using 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.