Solved by verified expert:Relationship of Height and WeightUsing 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.
