X is Mean Weight (lbs) 213.2 119.2 132.7 148.2 135.7 167.5 132.7 122.9 179.5 184.6 144.6 179.5

Y is Mean Relief Time (hrs)

4.1 9.4 6.8 4.1 8.5 5.9 8.1 10.5 4.1 3.3 7.2 6.6

Type the data into Excel and use the Excel functions listed to determine the value of each of the following. Note: The first two functions must have the range of y-values listed first.

Excel Function Value

Slop of the least squares line (b) =SLOPE (#:#) Intercept of the least squares line (a) =INTERCEPT(#:#) Correlation coefficient (r) =CORREL(#:#) Coefficient of determination (r2) =CORREL(#:#)^2