25 Aug Determine the linear correlation and regression equation between two variables to make predictions for the dependent variable.
eliverable 6 – Analysis with Correlation and Regression
Assignment Content
Competency
Determine the linear correlation and regression equation between two variables to make predictions for the dependent variable.
Student Success Criteria
View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.
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. Download the Excel spreadsheet provided below with the data and questions.
Instructions
The variables studied in the Excel sheet are:
Magnitude measured on the Richter scale
Depth in km
Deliverable 6 – Analysis with Correlation and Regression.xlsx Analyze the data and answer the questions presented on the Excel sheet.
The Excel spreadsheet contains four tabs. The first tab, labeled “data”, contains the data you will be using in your calculations. The next three tabs contain questions for you to complete. Ensure that you are completely answering all questions with steps shown, explanations, and correct formatting.
Requirements: Complete answer
