LinearRegressionQuestions

.docx

School

Florida State College at Jacksonville *

*We aren’t endorsed by this school

Course

2023

Subject

Aerospace Engineering

Date

Apr 3, 2024

Type

docx

Pages

3

Uploaded by GrandKangarooMaster374

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.
Question #3 a) What is the value of the linear correlation coefficient? r = - 0.949 Does the sign of the correlation coefficient match what you expected in Question 1? Yes, it matches. b) Determine whether a linear relation exists between the pressure and the wind. What is the critical value? [You can access the critical values for correlation in Table II on p A-2 of the eText in MyStatLab] Yes , the linear relation exists between the pressure and the wind because the linear correlation coefficient is close to -1, and the absolute value of the correlation coefficient is greater than the critical value 0.396 . Question #4 a) Predict the expected maximum wind speed for a hurricane with a minimum pressure of 970 mb y = (-1.383 * 970) + 1442.254 = 100.744 b) Should you use your regression line to predict the maximum wind speed for a hurricane with a minimum pressure of 850 mb. Explain why or why not. No, because the pressure of 850 mb is outside the scope. Question #5 a) In 2022 hurricane Ian had a minimum pressure of 937 mb. Use your regression line to predict the Ian’s maximum wind speed. y = (-1.383 * 937) + 1442.254 = 146.383
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help