You want to explore if there is a linear relationship between individual all-around final score and vault apparatus final score. In worksheet "Individual and Apparatus", manipulate data so that you have two column data below with 42 rows (the first 10 rows are given below, you need to fill out the rest of 32 rows). Individual all round Final Score Vault Apparatus Final Score 58.35 15.35 58.65 15.3 59.55 14.85 53.35 14.5 54.35 14.35 52.55 14.1 53.1 14 53.7 14.45 54.85 13.9 50.15 13.65 a. Construct a scatter plot between "individual all around final score" and "vault apparatus final score". Do you observe a linear patter? b. Perform regression analysis to test if there is a linear relationship between "individual all around final score" and "vault apparatus final score". State the null and alternative hypothesis; calculate the test statistics, find critical value, make a statistical conclusion, make a managerial conclusion. c. Can you base the regression model, estimate the vault apparatus final score when individual all around final score is 67.50?

PLEASE PROVIDE FULL ANSWERS WITH EXCEL ANSWERS PLEASE

individual all around Final Score 58.35 58.65 59.55 53.35 54.35 52.55 53.1 53.7 54.85 50.15 48.95 47.25 52.85 58.05 54.75 57.7 56.85 56.15 55.8 55.05 78.584 82.234 80.217 73.734 79.45 75.067 71.85 74.9 76.95 75.8 77.2 79.35 74.85 75.35 75.85 74.05 75.4 56.95 73.4 69.65 66.25 69.15 Vault apparatus final score

15.35 15.3 14.85 14.5 14.35 14.1 14 14.45 13.9 13.65 13.55 13.5 13.5 15.4 15.2 15.05 14.95 14.85 14.85 13.9 14.55 14.55 14.2 14.15 13.85 13.55 13.3 13.25 15.7 14.9 14.7 14.45 14.3 13.9 13.55 13.3 13 12.9 12.8 12.75 12.75 12.55