Biostatistics help!Need help please solving and putting in excel format. Please help!

100 Conditional Format as Cell Format Painter BIU YO AV Merge & Center $ ~ % 00 Formatting ~ Table ~ Styles v Clipboard Font Alignment Number Styles X Y fx A B C D E F G M O P leasurements of X: weight (in kilograms; kg) and Y: blood glucose levels (in milligrams per 100 milliliters; mg/100 mL) were made n 29 apparently healthy adult males. The summary data are as follows: EX, = 663.59, EY, = 1301. 49, SSxx = 2351.84 , SSvy = 926.49, SSxy = 941.90 A. Determine the least squares fit of Y on X and specify the fitted equation. + 12 B. Construct an Analysis of Variance (ANOVA) table to test for significant fit of the model. Be sure to include all components: the Ho and HI, ANOVA table, Sum of S and Mean Squares for the Regression and Residual, F test statistic value, p-value, Total row, conclusion in 2 sentences in which the first and second sentences describe numerically why you reject or accept Housing the p-value as a criterion and what this means in the context of the true population slope parameter, and your p-value 13 interpretation. Please note that it is not necessary to report all 5 steps of hypothesis testing for this problem though technically one could do so. 14 15 16 17 18 19 20 C. Compute the coefficient of determination, r2, and provide an interpretation. 27 22 23 24