I need exel file for calculations

Here is the data set:

SYSTOLIC BP WEIGHT

132 173

143 184

153 194

162 211

154 196

168 220

137 188

149 188

159 207

128 167

166 217

1. The independent variable would be the X which is the systolic blood pressure. The dependent variable would be the Y which is the weight. 2. Without drawing a scatterplot, I would expect to see a positive correlation. With positive correlations, as X increases, Y also increases. This seems to be happening with this data.

3. I would also expect to have a strong correlation. Because the values all seem fairly near each other. I created a scatter plot, and most points do stay pretty near, if not on the linear treadline. 4. My r = 0.97, I found this by using the correl function in Excel. This confirms I have a very strong correlation because the r is extremely close to the value of 1. 5. I used my knowledge from the Knewton lesson to populate the equation using Excel. The equation of the regression line is: y = 1.2332x + 9.9031 6. Using the equation, I can predict that if a person has a normal systolic blood pressure of 120, they probably weigh around 148 pounds.