Explore BrainMass

Explore BrainMass

    Bivariate Regression in Excel

    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. Check your work by using Excel's function =CORREL(array1,array2). Find t.05 for a two-tailed test for zero correlation. (d) Calculate the t test statistic. Can you reject rho = 0? (e) Use Excel's function =TDIST(t,deg_freedom,tails) to calculate the two-tail p-value.

    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 3, 2020, 9:16 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/bivariate-regression-174322

    Attachments

    Solution Summary

    This solution answers questions regarding regression analysis in Excel.

    $2.19

    ADVERTISEMENT