Explore BrainMass

Excel: Calculating a Correlation Using Statistical Functions

Compute the correlation analysis using the statistical functions in Excel. A Pearson Product Movement Correlation Coefficient. See the attached file.


Solution Preview

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 ...

Solution Summary

This solution explains and demonstrates how to calculate and interpret Pearson's r (correlation) using Excel.