Q6. (30 POINTS) The director of an alumni association for a small college wants to determine if ther

Q6. (30 POINTS) The director of an alumni association for a small college wants to determine if there is any type of relationship between the amount of contribution and the years that the alumnus has been out of school.Years (X) 1 5 3 10 7 6 12 4Contribution (Y) 500 100 400 50 75 80 20 200a. Using Excel construct a scatter plot. Discuss the output of the scatter plot.b. Give (or calculate) the correlation coefficient.c. Give (or calculate) the coefficient of determination.d. Give (or calculate) the regression equation coefficients; Give the equation of regression.e. (very important)Based on the above values, in detail draw the conclusion:• Discuss the correlation coefficient r• Discuss the coefficient of determination r2• Discuss in detail the meaning of the regression equationf. After how many years alumni will stop contributing?