Step by Step Solutions

[Solution Library] Construct a scatter plot including the regression line using excel for the given data. Determine whether there is a positive linear correlation,

Question: Construct a scatter plot including the regression line using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r. (References: example 1 - 4 pages 498 - 500; end of section exercises 15 - 22 pages 508 - 509)

  1. The data below are the ages and systolic blood pressure (measured in millimeters of mercury) of 9 randomly selected adults.
Age, x 38 41 45 48 51 53 57 61 65
Pressure, y 116 120 123 131 142 145 148 150 152

a: Scatter plot with regression line. (3 points)

b: Type of correlation (positive linear correlation, negative linear correlation, or no linear correlation) (2 points)

c: Complete the table and find the correlation coefficient r.

(5 points)

x y xy x 2 y 2
38 116
41 120
45 123
48 131
51 142
53 145
57 148
61 150
65 152

Use the last row of the table to show the column totals.

n = 9

Price: $2.99
Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document


∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in