Based on what you have learned from your research on regression analysis and correlation, answer the following questions about the Body Fat Versus Weight data set:

• When performing a regression analysis, it is important to first identify your independent/predictor variable versus your dependent/response variable, or simply put, your x versus yvariables. How do you decide which variable is your predictor variable and which is your response variable
• Based on the Body Fat Versus Weight data set, which variable is the predictor variable? Which variable is the response variable? Explain.
• Using Excel, construct a scatter plot of your data.
• Using the graph and intuition, determine whether there is a positive correlation, a negative correlation, or no correlation. How did you come to this conclusion?
• Calculate the correlation coefficient, r, and verify your conclusion with your scatter plot. What does the correlation coefficient determine?
• Add a regression line to your scatter plot, and obtain the regression equation.
  • Does the line appear to be a good fit for the data? Why or why not?
  • Regression equations help you make predictions. Using your regression equation, discuss what the slope means, and determine the predicted value of weight when body fat equals 0. Interpret the meaning of this result

Document Preview:

fat
IDNO
BODYFAT
WEIGHT
Statement:
Description:
The dataset provided here is based on a sample of 252 men.
Their body fat and weights were recorded.
The doctors office claims that the mean body fat in men is 20%.
Source: http://www2.stetson.edu/~jrasp/data.htm
Body Fat
Body Weight
Mean
Median
Range
Standard…

Attachments:

weight_data_1….xls