Explore BrainMass

Explore BrainMass

    Regression Equation for Males Eating Junk Food

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

    1. Figure out the regression equation for males based on what they spend on junk food and their weight. The weight is the independent variable. Do we have a correlation?
    2. Figure out the regression equation for females based on what they spend on junk food and their weight. Do we have a correlation?
    Note: For the first part you need to calculate the regression coefficients and place them in the regression equation. You should end up with two equations, one for males and one for females. It should look like
    Y' = mX + b
    For the second part you need to find the correlation coefficient ( r ) for males and correlation coefficient ( r ) for females. Student test to prove correlation will assist you in the decision and use the level of significance of .05 to tell me if there is a relationship between the variables.

    Below is the survey results:

    Gender $junk food/week Weight
    M $50.00 295
    M $5.00 270
    M $30.00 165
    M $10.00 220
    M $0.00 140
    M $5.00 175
    M $10.00 175
    M $20.00 235
    M $10.00 235
    M $25.00 185
    M $12.00 200
    M $35.00 215
    M $37.00 300
    M $15.00 150
    M $25.00 185
    M $10.00 170
    M $22.00 220
    M $35.00 195
    M $15.00 225
    M $10.00 180
    M $35.00 275
    M $15.00 205
    M $20.00 170
    M $10.00 205
    M $5.00 190
    M $25.00 210
    M $0.00 175
    M $15.00 185
    M $10.00 205
    M $27.00 165
    M $10.00 190
    M $27.00 225
    M $30.00 265
    M $30.00 150
    M $19.00 175
    M $25.00 170
    M $36.00 220
    M $18.00 180
    M $20.00 180
    M $3.00 190
    Total $761.00 8065

    Gender $junk food/week Weight
    F $50.00 170
    F $0.00 121
    F $10.00 175
    F $20.00 128
    F $2.00 170
    F $0.00 175
    F $20.00 140
    F $15.00 195
    F $19.00 157
    F $7.00 160
    F $10.00 175
    F $10.00 165
    F $8.00 175
    F $17.00 170
    F $5.00 110
    F $18.00 180
    F $30.00 200
    F $10.00 250
    F $15.00 185
    F $10.00 175
    F $10.00 120
    F $15.00 160
    F $10.00 145
    F $5.00 130
    F $30.00 185
    F $15.00 135
    F $15.00 150
    F $0.00 115
    F $10.00 130
    F $5.00 125
    F $13.00 170
    F $12.00 155
    F $4.00 140
    F $8.00 120
    F $10.00 105
    F $22.00 98
    F $18.00 175
    F $10.00 190
    F $17.00 170
    F $12.00 145
    Total $517.00 6239

    © BrainMass Inc. brainmass.com June 3, 2020, 7:48 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/regression-equation-for-males-eating-junk-food-111901

    Solution Preview

    See attached word document for analysis. The data analysis is in the stat.xls (an Excel file)

    1. Figure out the regression equation for males based on what they spend on junk food and their weight. The weight is the independent variable. Do we have a correlation?

    Use Excel(see the first two columns in the sheet 1), we get the following table.(on sheet 4).

    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.430005
    R Square 0.184904
    Adjusted R Square 0.163454
    Standard Error 10.67935
    Observations 40

    ANOVA
    df SS MS F Significance F
    Regression 1 983.1316 983.1316 8.620294 0.005617
    Residual 38 4333.843 114.0485
    Total 39 5316.975

    ...

    Solution Summary

    Excel and Word documents show how to find the regression equation and coefficients.

    $2.19

    ADVERTISEMENT