QUESTION 04 (20 points) - Simple Linear Regression (SLR) We have the following hypothetical data for the independent variable x (other names: regressor, covariate, or explanatory variable) and the dependent variable y (regressand). (a) Use Excel to draw a yx scatter diagram with y on the vertical axis. Add the linear trend line. (b) Complete the table. Use 4 decimal places throughout your calculations if applicable. (c) Give an equation for and manually calculate the slope b1. The table aids your calculations. (d) Give an equation for and calculate the y-intercept b0. Again, the table would help. (e) Write the sample regression equation with numerical coefficients. (f) Calculate predicted value for y at x=7.0 (within x-data range interpolation). (o) Calculate oredicted value for v at x=1.0 loutside x-data range extrannlation)