In: Statistics and Probability
For the attached data set, create a simple linear regression equation defining the relationship between height and weight. Use the regression equation to predict the weight for a given height of 5.75 inches PLEASE PROVIDE EXCEL STEP CALCULATIONS
|
Path
Data---->>> Data analysis ---->>>Regression ---->>> Ok --->>
Select input y range
Select input x range
Give output range
Then hit on ok.
The regression equation is
Predict weight = -78.5632597 + 39.68227137 Height