Need 150 word response to Business Statistics question

Relationship of Height and Weight

  • Using the given Height and Weight data set, follow the steps in the weekly video or on pages 584-585 of the textbook for performing a regression analysis using Excel to analyze the Height and Weight Data set (assume height is the input variable x and weight is the output variable y).
  • Once you have performed the analysis in Excel, state the correct simple linear regression equation and use the regression equation to predict the weight (in pounds) of a person who is 65 inches tall and the weight (in pounds) of a person who is 100 inches tall.
  • Why might the regression equation you have found not be a good predication of the weight of someone who is 100 inches tall?

Download the Height and Weight Table Here.