Explore BrainMass

Explore BrainMass

    Sample Correlation

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

    (a) Make an Excel scatter plot. What does it suggest about the population correlation between X and Y?
    (b) Make an Excel worksheet to calculate SSxx , SSyy, and SSxy.

    Use these sums to calculate the sample correlation coefficient.
    (Use table below to solve regression)

    Part-Time Weekly Earnings ($) by College Students

    Hours Worked (X) Weekly Pay (Y)
    10 93
    15 171
    20 204
    20 156
    35 261

    © BrainMass Inc. brainmass.com June 4, 2020, 12:19 am ad1c9bdddf
    https://brainmass.com/business/accounting/sample-correlation-332008

    Solution Summary

    Makes
    a) an Excel scatter plot.
    (b) an Excel worksheet to calculate SSxx , SSyy, and SSxy.

    $2.19

    ADVERTISEMENT