Use Excel to obtain the following values: (A ) What is the value of the slope for the regression equation when predicting women's heights from men's heights? (B ) Obtain the value of the y intercept. (C) Provide an interpretation of the y intercept obtained in part B. (D) Create a scatterplot for the data above and plot the regression line. (E) What are the predicted heights for wives whose husbands' heights are: 70, 69, and 67?Regression Statistics Multiple R 0.665972141 R Square 0.443518893 Adjusted R Square 0.373958755 Standard Error 0.387620818 Observations 10 ANOVA of SS MS F gnificance F Regression 0.958 0.958 6.37605 0.03553 Residual 1.202 0.15025 LD CO Total 2:16 Coefficients andard Err tStat P-value Lower 95%%Jpper 95%ower 95.01pper 95.0% Intercept 2.307171744 0.33706 6.845 0.00013 1.52991 3.08443 1.52991 3.08443 X - AGE 0.025411162 0.01006 2.52508 0.03553 0.0022 0.04862 0.0022 0.04862 RESIDUAL OUTPUT Observation Predicted Y - GPA|Residuals 1 3.37444055 0.02556 2,993273119 0.10673 W N 2.815394985 -0.0154 4 2.866217309 0.1662 5 3.272795902 0.3272 80 6 2.917039683 -0.017 7 2.840806147 0.35919 2.866217309 -0.7662 LD DO 3.221973578 0.47803 10 B.831841467 -0.8318