Stat 3309 - Statistical Analysis for Business Applications I

Consider the following data representing the total time (in hours) a student spent on reviewing for the Stat 3309 final exam and the actual score on the final. The sample of 10 students was taken from a class and the following answers were reported. time score

0 23

4 30

5 32

7 50

8 45

10 55

12 60

15 70

18 80

20 100

Part 1: Use the formulas provided on the 3rd formula sheet to compute the following quantities. Open an Excel spreadsheet and write the table with data given above. Add columns for x 2 , y 2 , and xy, as well as the last row for (Is this also the residual, How can i calculate for it?)