Module 06 Content ScenarioAccording to the U.S. Geological Survey (USGS), the p

Module 06 Content
ScenarioAccording 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.InstructionsThe variables studied in the Excel sheet are:Magnitude measured on the Richter scale
Depth in km
Deliverable 6 – Analysis with Correlation and Regression
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 you completely answer all questions with steps shown, explanations, and correct formatting.