i jut found an assignment and i am working on my own to improve my stats skills but i need help help please

the first test score was 47.83332% and the second test was 85.46037%

here is the data

Test 1 Test 2

71.27 75.14

107.27 96.47

56.36 47.83

67.27 54.46

51.27 52.54

51.27 50.51

80 80.33

65.45 61.46

87.27 87.17

83.64 80.28

42.18 63.98

60.36 82.31

83.64 89.36

63.64 58.69

63.64 20.91

73.09 84.23

69.09 53.93

100.36 95.94

87.27 84.5

87.64 87.6

101.82 101.02

80 79.95

84 75.31

53.09 47.89

53.09 67.65

74.91 48.43

58.55 67.4

105.45 90

101.82 85.35

50.91 50.83

87.27 89.37

47.64 57.72

80 82.2

82.18 84.07

93.09 83.97

63.64 61.78

69.09 58.04

107.27 94.6

29.09 32.55

102.18 80.48

85.45 84.55

105.45 97.81

84 85.14

93.09 81.4

67.64 60.34

96.36 68.25

92.73 67.49

45.82 87.81

90.91 92.94

87.27 90.86

85.45 93.58

90.91 95.72

54.91 29.67

101.82 91.93

105.45 96.47

81.82 47.3

51.27 49.12

- 64.3

31.27 85.46

100 85.19

90.91 90.38

74.55 80.22

81.82 61.09

78.18 58.47

109.09 95.35

87.27 84.98

76.73 80.55

Questions

Is there a linear relationship between these two variables?

If so, how strong is the relationship?

Can we create a linear model to predict a Test 2 score given a Test 1 score?

Does this model do a good job of predicting your Test 2 score?

1.Use the data set to create a scatter plot of the two variables, Test 1 and Test 2 scores.Because we will be using Test 1 scores to predict Test 2 scores, Test 1 with be the explanatory (x) variable and Test 2 will be the response (y) variable.Does it appear that there is a linear relationship according to the scatter plot?

2.Compute the value of the linear correlation coefficient (the value of r).

3.Interpret the relationship between Test 1 and Test 2 scores using the value of r.Be sure to describe the strength and direction in your explanation.

4.Compute the linear regression equation (the linear model) for the variables Test 1 scores and Test 2 scores.Be sure to include the variables, Test 1 and Test 2, for the x and y variables with an equal sign.

5.Find your Test 1 score in the data set; this will be the explanatory (x) value you will use in the model.You may have to look in the "My Grades" tab in Blackboard if you can't recall your first test score.

6.Find your Test 2 score in the data set; this will be the actual response (y) value you will use to compute the residual.

7.Use the linear model and your actual Test 1 score to predict your Test 2 score; this will be the predicted response (y) value you will use to compute the residual.

8.Compute the residual value for your Test 2 score.

Recall: Residual = actual Test 2-value -predicted Test 2-value.

9.Did the model overestimate or underestimate your actual Test 2 score?

10.Given your answer in question 8, do you believe this linear model was a useful model?Explain your answer here:Click here to enter text.