Using Excel to Calculate and Graph Correlation Data

Calculating Pearson’s r Correlation Coefficient with Excel

Usng Excel to calculate correlation coefficients

Using Exel to calculate correlation coefficients

Creating a Scatterplot of Correlation Data with Excel

Graphing Instructons

Using Excel to calculate a scatterplot