Answer Happy

Name Test Grade and Test Review Grade-Suppose I collected scores for the Test Review grade and the Test 3 grade from Pearson/Blackboard for the previous class. The objective is to determine the relation between the Test 3 Review grade and the Test 3 grade. a) In Excel, go to Tools/Data Analysis and from the "Analysis Tools" box select Regression. Run the regression application to find bo and b₁. Write the estimated equation using bo and b, values. b) Find the value of the standard error of the estimate, se. Write 1-2 sentences to interpret the standard error of the estimate. c) Find the coefficient of determination on the Excel output. Write 1-2 sentences to interpret the coefficient of determination. d) Use the Classical Approach to test whether a significant relation exists between the Test Review grade and the Test 3 grade (use a two-tail test with a = 0.05). Show all 4 steps of the test of a hypothesis. Information for this test is available from the regression output. Interpret your conclusion in the context of the problem. e) Find the p-value from the Excel output. Test the hypothesis using the P-Value Decision Rule. State your conclusion and the basis of the conclusion based on the p-value decision rule. 1) Predict the Test 3 grade if the Test Review grade is 40. Show your calculations. g) Predict the test grade if the Test Review grade is 80. Show your calculations.
X=Test Review Grade 72.9 46.9 28.0 18.4 92.9 40.8 92.7 23.2 59.1 79.3 0.0 51.1 33.9 33.2 0.0 20.6 0.0 79.3 58.1 40.8 64.0 0.0 13.4 8.3 44.7 73.0 24.7 94.4 0.0 80.7 0.0 82.1 49.0 Y=- Test 3 Grade 76.4 84.8 51.7 45.8 93.9 25.4 80.2 62.1 78.1 78.2 35.1 79.4 80.3 49.0 32.1 56.5 38.0 78.9 48.4 45.3 79.2 43.0 51.8 27.3 67.0 78.0 68.8 88.7 50.3 54.5 60.0 92.6 78.3 I
Obs. # X = Review Grade 72.9 46.9 28 18.4 92.9 40.8 92.7 23.2 59.1 79.3 0 51.1 33.9 33.2 0 20.6 0 79.3 58.1 L23 789 1 4 5 6 10 11 12 13 14 15 16 17 18 19
Y=Test 3 Grade 76.4 84.8 51.7 45.8 93.9 25.4 80.2 62.1 78.1 78.2 35.1 79.4 80.3 49 32.1 56.5 38 78.9 48.4