Question

The heights (in inches) and weights (in pounds) of 25 baseball players are given below. Use Excel to find the best fit linear regression equation, where height is the explanatory variable. Round the slope and intercept to two decimal places.

Height   Weight
71   186
72   211
73   220
70   165
72   180
72   195
70   175
74   202
78   240
71   170
74   180
73   185
76   257
77   215
76   287
77   220
73   200
76   223
76   200
70   220
75   215
71   195
77   194
75   195
75   225

Answer 1

We can directly use here Excel for regression,

Step1) Enter data in Excel.

Step 2) Data >>data analysis >>Regression >> select x and y values separately >>ok

Therefore, regression equation is,

y=6.53x-275.47

i.e. Weight = 6.53*Height -275.47