Fall Semester 2002

Practical Two Fri 9:30 Dec 13

Consider this data: 

 x       y
-------------
 1	30 
 2	28 
 2	29 
 3	25 
 4	30
 4	28
 5	25
 6	24
 7	26
 7	22
 8	20
 9	18
 9	14
10	14
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 = 14 above, below, or exactly average?

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