Question: You are a teacher for a statistic class, and you have measured the number of hours student are actively participating in your course’s statistical online tutorial. You have also recorded the final exam scores for these students. The maximum score on the test is 250 points. The table below shows the number o tutorial hours and the final grade scores each of the 24 students.

Submit work in an Excel File

1. Using Excel or PHStats, conduct a regression analysis of these data and report the following:

1. Correlation coefficient
2. R ² for the two data variables. (What does this mean about the regression line?)

ii. Write the equation of the regression line.

iii. Describe what your results mean in plain English. How reliable predictor is tutorial hours and final exam score?

iv. What does the residual plot tell you?

v. Calculate the expected final grade score for a student who uses the tutorial for 100 hours and for 200 hours.

vi. From your calculated results for final exam scores for #5 above, what are your comments about the benefits of interpolations and extrapolations of the data?

Table 7

Student Tutorial Activity & Final Exam Results

Price: $2.99

Solution: The downloadable solution consists of 5 pages
Deliverable: Word Document