Explore BrainMass
Share

Explore BrainMass

    Excel: Calculating a Correlation Using Statistical Functions

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

    © BrainMass Inc. brainmass.com October 10, 2019, 12:33 am ad1c9bdddf
    https://brainmass.com/statistics/pearson-product-moment-correlation/excel-calculating-a-correlation-using-statistical-functions-296471

    Attachments

    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.

    $2.19