## Description

# 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?

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Explanation & Answer

See attached

Answer

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.716178204

R Square

0.51291122

Adjusted R

Square

0.510602742

Standard Error

22.74081438

Observations

213

ANOVA

df

Regression

Residual

Total

Intercept

Height

1

211

212

Coef...