Q6 25 POINTS Consider the following data One of the stores

Last updated: 5/22/2023

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 300 250 200 150 100 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 50 0 1 250 1 2 5 3 10 100 110 0 3 4 6 70 5 6 Years Contribution 6 2 80 175 7 3 e very important Based on the above values in detail draw the conclusion Discuss the correlation coefficient r 8 8 25 9 4 120 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 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