Homework: Analysis with Correlation and Regression
Competency
Determine and interpret the linear correlation coefficient, and use linear regression to find a best fit line for a scatter plot of the data and make predictions.
Scenario
According to the U.S. Geological Survey (USGS), the probability of a magnitude 6.7 or greater earthquake in the Greater Bay Area is 63%, about 2 out of 3, in the next 30 years. In April 2008, scientists and engineers released a new earthquake forecast for the State of California called the Uniform California Earthquake Rupture Forecast (UCERF).
As a junior analyst at the USGS, you are tasked to determine whether there is sufficient evidence to support the claim of a linear correlation between the magnitudes and depths from the earthquakes. Your deliverables will be a PowerPoint presentation you will create summarizing your findings and an excel document to show your work.
Concept being Studied
a. Correlation and regression
b. Creating scatterplots
c. Constructing and interpreting a Hypothesis Test for Correlation using r as the test statistic
You are given a spreadsheet that contains the following information:
a. Magnitude measured on the Richter scale
b.Depth in km
Using the spreadsheet, you will answer the problems below in a PowerPoint presentation.
What to Submit
The PowerPoint presentation should answer and explain the following questions based on the spreadsheet provided above.
I. Slide i: Title slide
II. Slide ii: Introduce your scenario and data set including the variables provided.
III. Slide iii: Construct a scatterplot of the two variables provided in the spreadsheet. Include a description of what you see in the scatterplot.
IV. Slide iv: Find the value of the linear correlation coefficient r and the critical value of r using α = 0.05. Include an explanation on how you found those values.
V. Slide v: Determine whether there is sufficient evidence to support the claim of a linear correlation between the magnitudes and the depths from the earthquakes. Explain.
VI. Slide vi: Find the regression equation. Let the predictor (x) variable be the magnitude. Identify the slope and the y-intercept within your regression equation.
VII. Slide vii: Is the equation a good model? Explain. What would be the best predicted depth of an earthquake with a magnitude of 2.0? Include the correct units.
VIII. Slide viii: Conclude by recapping your ideas by summarizing the information presented in context of the scenario.
Format your homework according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
Attachment:- Deliverable-Data.rar