\fa) 15 pts. Generate the following scatter plots and fit a trend line using the add trendline command. (Show the trend line equation and variance of the fitting linear model, R2 ) i. Foot length (y) versus Height (x) i. Foot length (y) versus Parent-guardian Age (x) iii. Height (y) versus Parent-guardian Age (x) b) 6 pts. Calculate correlations for each of the above pairs using CORREL function of excel c) 27 pts. Use the regression tool under Data Tab and Data Analysis Menu in Excel to test how good each line model is for a confidence level of 95%. Indicate the important variables for each linear regression y = mx + b by filling the following table Foot length(y) Foot length(y) Height(y) Height (x) Parent-Guardian Age (x) Parent-Guardian Age (x) Line 1 (9pts) Line 2 (9pts) Line 3 (9pts) Standard Error Variance Correlation coeff Degrees of freedom Intercept Slope P value of Ha Lower bound of slope for 95% Confidence Interval Lower bound of slope for 95% Confidence Interval d) 7 pts. Which one of the lines indicate the strongest relationship? Indicate which one of the statistical variables in the above table provide this evidence by putting an X mark to the relevant cell Foot length(y) Foot length(y) Height(y) Height (x) Parent-Guardian Age (x) Parent-Guardian Age (x) Line 1 Line 2 Line 3 Standard Error Variance Correlation coeff Degrees of freedom Intercept Slope P value of H. Lower bound of slope for 95% Confidence Interval Lower bound of slope for 95% Confidence IntervalB C E G M N O P Q R Foot Size Foot Size |occurrence Parent Age Parent Ageoccurrence Height Height occurrence 40 16 46 14 10 38 ONDOO 7 8 9 Parel 38 30 w 70 70 N 70 71 71 71 71 40 41 43 46 47 49 50 71 72 NW 55 60 61 62 63 64 65 original data histograms +