I’m trying to study for my Statistics course and I need some help to understand this question.

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.

Concepts Being Studied

You are given a spreadsheet that contains the following information:

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.

Along with your PowerPoint presentation, you should include your Excel document which shows all calculations.