Fall Semester 2002

Practical Two Fri 4pm SB221 Dec 13

Consider this data: 

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

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