Share
Explore BrainMass

Regression Equation for Males Eating Junk Food

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

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