Question

A pediatrician wants to determine the relation that may exist between a​ child's height and head circumference. She randomly selects 5 children and measures their height and head circumference. The data are summarized below.

Height_(inches)_-_x   Head Circumference_(inches)_-_y
26   17.3
24.5   17.1
27.75   17.6
26.5   17.3
27   17.5

​(a) Treating height as the explanatory​ variable, x, use technology to determine the estimates of β0 and β1.

β0≈=b0=__?__

​(Round to four decimal places as​ needed.)

β1≈b1=__?__

​(Round to four decimal places as​ needed.)

Answer 1

We can directly use Excel.

Step 1) Enter data in Excel .

Step 2) Data >>Data analysis >>Regression >>Select y and x values separately >>Ok

β0≈b0=13.2857..................y intercept

β1≈b1=0.1546........................slope