Fall Semester 2002


Practical Two Tue 11:15 Dec 11

Consider this data:

 x       y
-------------
 1	 3
 2	 8
 2	 7
 3	 9
 4	12
 4	14
 5	15
 6	19
 7	21
 7	23
 8	25
 9	30
 9	27
10	30
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 = 30 above, below, or exactly average?


Last updated: Oct 29, 2002 by Adrian German for A113