please explain how to get these answers and if you could show it through excel it would be really helpful Recall that b, is the estimate of the slope of the regression line B1. Use technology or the...

please explain how to get these answers and if you could show it through excel it would be really helpful

Extracted text: Recall that b, is the estimate of the slope of the regression line B1. Use technology or the formula below to calculate sp,- Se


Extracted text: 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. Complete parts (a) through (f) below. Height (inches), x Head Circumference (inches), y 16.9 17.5 17.3 17.1 17.3 25 27 26.5 25.5 260 Click the icon to view the Student's t-distribution table. (a) Treating height as the explanatory variable, x, determine the estimates of Po and B1. Po z bo = 9.940 P, zb, = 0.280 (Round to three decimal places as needed.) %3D (b) Compute the standard error of the estimate, s,. Se = 0.0632 (Round to four decimal places as needed.) (c) A normal probability plot suggests that the residuals are normally distributed. Determine So. = 0.0400 %3D The unbiased estimator of o is called the standard error of the estimate, s. Read the value of s, from the software output of the regression analysis or use the formula below to calculate sę, where y; -yi is the residual between the observed value, y;, and the predicted value of y, y;- n-2