The data below represent the number of absences and the final grades of 9 randomly selected students from a statistics class ...

     1. The   data below represent the number of absences and the final grades of 9   randomly selected students from a statistics class. Using Excel, construct a   scatter plot for these data. Determine whether there is a positive linear   correlation, negative linear correlation, or no linear correlation. Complete   the table and find the correlation coefficient r (You may also use Excel   rather than completing the table and calculating the correlation coefficient   by hand).    Absences, x 4 7 10 8 13 6 19   12 9   Final grade, y 99 87 81 83 72   93 56 77 83      a: Scatter plot (3.5 points)

     b: Type of   correlation (positive linear correlation, negative linear correlation, or no   linear correlation) (2.5 points)         c:   Complete the table and find the correlation coefficient r.    

     x y 4 99   7 87   10 81   8 83   13 72   6 93   19 56   12 77   9 83