Please use excel in solving this:

1. (30 pts) We wish to determine a regression equation that relates the length of an infant (in cm) to age (in days), gender and weight at birth (in kg). Below is portion of the regression analysis derived using a software. *Note: under the gender variable: male and female categories are assigned a value of 1 and 0, respectively. Source SS df Coef. Std. Err. Model 316.8866 3 age 0.4798 0.0980 Residual 71.4734 8 weight 0.4020 1.0454 gender 1.3113 1.9591 intercept 19.53 7.7829 a. What is the sample size for this problem? b. Write the estimated regression equation, interpret each slope coefficients, use the proper unit of measurement. c. Test for significance of the Bage, Bweight, and Bgender at the 99% confidence level. d. From (b) which parameter/s is/are statistically significant. e. Test whether or not there is a significant relationship between the infant's length and the independent variables. Use a .01 level of significance. Use only the critical value approach. f. Provide the Coefficient of Determination, interpret. g. Determine the Adjusted R2, compared this with the value obtained from letter (d), are there any difference? Why? h. Estimate the length of a female infant that is 101 days old and weighs 5.83 kg