Deliverable 6 - Analysis with Correlation and Regression item options
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. Your deliverables will be a PowerPoint presentation you will create summarizing your findings and an excel document to show your work.

Concepts Being Studied
Correlation and regression
Creating scatterplots
Constructing and interpreting a Hypothesis Test for Correlation using r as the test statistic

You are given a spreadsheet that contains the following information:

Magnitude measured on the Richter scale
Depth in km

Deliverable 6 - Analysis with Correlation and Regression.xlsx

Using the spreadsheet, you will answer the problems below in a PowerPoint presentation.

What to Submit
The PowerPoint Assignment presentation should answer and explain the following questions based on the spreadsheet provided above.

Slide 1: Title slide

Slide 2: Introduce your scenario and data set including the variables provided.

Slide 3: Construct a scatterplot of the two variables provided in the spreadsheet. Include a description of what you see in the scatterplot.

Slide 4: 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.

Slide 5: Determine whether there is sufficient evidence to support the claim of a linear correlation between the magnitudes and the depths from the earthquakes. Explain.

Slide 6: Find the regression equation. Let the predictor (x) variable be the magnitude. Identify the slope and the y-intercept within your regression equation.

Slide 7: 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.

Slide 8: Conclude by recapping your ideas by summarizing the information presented in context of the scenario.

Along with your PowerPoint presentation, you should include your Excel document which shows all calculations.
This assignment falls under the inferential section of your online statistics class. My Course Tutor experts are competent at handling such assignments. The firs step in handling a statistics assignment is to understand the nature of the data, and to review the possible category of data analysis methods within which hypothesis testing falls. The excel file for this assignment has been attached.

Deliverable 6 - Analysis with Correlation and Regression.xlsx

Confidence Intervals and Hypothesis Testing
Questions 10 through 12 are based on hypothesis testing and confidence intervals. In the different textbooks you will find many criteria about when to use normal distribution and t distribution for solving these problems. Some of the criteria defined are based on approximation that when sample size is large, t distribution can be approximated to normal. However, here when you are using technology to solve problem, stick to criteria that when population standard deviation is known, normal distribution is used. In all other cases or respective of sample sizes, t distribution is used.
Q10) Consider variable overall satisfaction with the dining facility variable.
a. At 90% confidence, estimate the overall satisfaction with the fining facility.
b. At a 10% significance level, can we conclude overall satisfaction is different from 3.5? Explain criteria used to reach conclusion.
Q 11) Let’s perform analysis on satisfaction based on frequency of visit variable. You may find table completed in Question 4 useful for this analysis. At 5% significance level, test the hypothesis that those who visit dining facility daily are less satisfied that those who to not visit facility daily, In the answers provide test statistics, P value and conclusion. Use subscript 1 for daily visit and 2 for those who don’t visit dining facility daily.
This question is an example of inferential statistics that can be addressed by our expert writers.

statistics help online question.docx