Excel Activity #2: Linear Regression
Use your Excel results to answer the following questions. Question #1
From the scatter plot, does there appear to be a linear relationship between pressure and wind speed?
Yes
, in the scatter plot I can see a linear relationship between pressure and wind speed. If so, is it a positive or negative relationship?
There appears to be a strong negative relationship.
Based on the scatterplot, would you expect the correlation and the slope of the regression equation to be positive or negative?
Based on the scatterplot, I expect the correlation and the slope of the regression equation to be negative.
Question #2
a) What is the least squares regression line (round values to 3 decimal places)?
y = -1.383x + 1442.254
Does the sign of the slope match what you expected in Question 1?
Yes,
they match. b) Interpret the slope in terms of this problem.
For every additional minimum pressure, the maximum winds decrease by 1.382 millibars.
c) Does the y
-intercept have a meaningful interpretation in this problem?
Not meaningful since x=0 is outside the scope of the data.
