Compute the correlation analysis using the statistical functions in Excel. A Pearson Product Movement Correlation Coefficient. See the attached file.
I've attached a file. The file has several comments in it explaining how to calculate all the values and how to make the scatterplot. The comments are marked by little red triangles in the upper ...
This solution explains and demonstrates how to calculate and interpret Pearson's r (correlation) using Excel.