Q6. (25 POINTS) Consider the following data: One of the stores is a proud sponsor of the college soccer team. They constantly try to raise money for the team and they want 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) Contribution (Y) 1 250 5 100 3 10 6 6 2 8 4 110 0 70 80 175 25 120 4 NOTE: For the following questions you can use excel analysis or a calculator, it is your choice. The scatter plot might give you most of the necessary information. a. Using Excel construct a scatter plot. Discuss the output of the scatter plot. Chart Title 300 250 200 150 100 50 0 1 2 3 4 5 6 7 8 9 Years -Contribution 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 r Discuss in detail the meaning of the regression equation f. (unrelated to the previous data) A company has a set of data with employee age (X) and the corresponding number of annual on-the-job-accidents (Y). Analysis on the set finds that the regression equation is Y=120-3.0*X.