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.