Fall Semester 2002


Practical Two Fri 11:15 Dec 13

Consider this data:

 x       y
-------------
 1	60 
 2	58 
 2	59 
 3	55 
 4	60
 4	58
 5	55
 6	54
 7	56
 7	52
 8	50
 9	48
 9	44
10	44
Enter the data in Excel then answer the following questions:

  1. What's the coefficient of correlation between x and y?
  2. What's the slope and intercept of the regression line?
  3. Plot the data and add a trendline to it.
  4. Can the regression line be used to summarize the values reliably?
  5. What's the value of y predicted by the regression line for an x of 4
  6. For x = 10 is the measurement of y = 44 above, below, or exactly average?


Last updated: Dec 13, 2002 by Adrian German for A113