1. Graphically show the linear relationship between % of Alumni Giving and Graduation Rate. (2 points) 2. Madam President believes that the % of Alumni Giving rate is influenced by all the other variables in the data set. a) Estimate the multiple regression model based on all the variables (categorical and quantitative). Provide the equation. (1 point) b) Test whether the multiple regression model as a whole is significant. At 0.05 level of significance what is your conclusion?(1 point) a) Interpret the value of the regression coefficient for the variable, TYPE, from the estimated multiple regression equation in( a) (1 point) Does the fact that a university is private, increase % of Alumni Giving rate?(1 point) What is the difference in % of Alumni Giving rate between a public and a private university? (1 point) b) Test to determine the significance of each independent variable separately. What is your conclusion at the 0.05 level of significance? (5 points) c) Eliminate any independent variable that is not significant from the estimated regression equation. What is your recommended estimated regression? (1 point) d) Use the model presented in (e) to estimate the % of Alumni Giving rate for Boston College (1 point)