Module 6: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. Your deliverables will be a PowerPoint presentation you will create summarizing your findings and an excel document to show your work. Concept 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 Using the spreadsheet, you will answer the problems below in a PowerPoint presentation.What to SubmitThe PowerPoint 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.Module 7:Please see attached document.
deliverable_07_questions_ma.docx
deliverable_06_data.xlsx
deliverable_07_data.xlsx
Unformatted Attachment Preview
Deliverable 07 Worksheet
Scenario
You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over
the past few days, you have noticed an increase in patients admitted with a particular
infectious disease. You believe that the ages of these patients play a critical role in the method
used to treat the patients. You decide to speak to your manager, and together you work to use
statistical analysis to look more closely at the ages of these patients.
You do some research and put together a spreadsheet of the data that contains the following
information:
● Client number
● Infection disease status
● Age of the patient
You need the preliminary findings immediately so that you can start treating these patients.
So, let’s get to work!
Background information on the Data:
The data set consists of 60 patients that have the infectious disease with ages ranging from
35 years of age to 76 years of age for NCLEX Memorial Hospital.
Requirements:
1) Answer the questions below in a PowerPoint presentation.
2) Include only the summary calculations in your slides (not formulas).
3) Show calculations in your Excel spreadsheet (include formulas and do not round the
numbers).
Slide 1: Title
Introduce your scenario and data set.
○ Slide 2: Provide a brief overview of the scenario you are given above and the
data set that you will be analyzing.
o Slide 3: Classify the variables in your data set.
Which variables are quantitative/qualitative?
Which variables are discrete/continuous?
Describe the level of measurement for each variable included in the data
set (nominal, ordinal, interval, ratio)
● Discuss the importance of the Measures of Center and the Measures of Variation.
o Slide 4: What are the measures of center and why are they important?
o Slide 5: What are the measures of variation and why are they important?
● Slide 6: Calculate the measures of center and measures of variation. Interpret your
results in context of the scenario.
o Mean


Median
Mode
Midrange
Range
Variance
Standard deviation
Slide 7: Discuss the importance of constructing confidence intervals for the population
mean by answering these questions:
o What are confidence intervals?
o What is a point estimate?
o What is the best point estimate for the population mean? Explain.
o Why do we need confidence intervals?
Slide 8: Construct a 95% confidence interval for the population mean. Assume that your
data is normally distributed and σ is unknown. Include a statement that correctly
interprets the confidence interval in context of the scenario.
Perform the following hypothesis test:
o Original Claim: The average age of all patients admitted to the hospital with
infectious diseases is less than 65 years of age.
Test the claim using α = 0.05 and assume your data is normally
distributed and σ is unknown.
o Answer the following:
1. Slide 9: Write the null and alternative hypothesis symbolically and
identify which hypothesis is the claim.
2. Slide 9: Is the test two-tailed, left-tailed, or right-tailed? Explain.
3. Slide 10: Which test statistic will you use for your hypothesis test; z-test
or t-test? Explain.
4. Slide 10: What is the value of the test-statistic? What is the p-value?
What is the critical value?
5. Slide 11: What is your decision; reject the null hypothesis, or do not
reject the null hypothesis?
a. Explain why you made your decision, including the results for
your p-value and the critical value.
6. Slide 11: State the final conclusion in nontechnical terms.
Slide 12: Conclude by recapping your ideas by summarizing the information presented
in context of the scenario.
o Include the mean, standard deviation, confidence interval with interpretation,
and results of the hypothesis test.
o What conclusions, if any, do you believe you can draw as a result of your study?
o What did you learn from the project about the population based on this sample?
What did you learn about the specific statistical tests you conducted?
o
o
o
o
o
o
4.
5.
6.
7.
MAG
0.70
0.74
0.64
0.39
0.70
2.20
1.98
0.64
1.22
0.20
1.64
1.32
2.95
0.90
1.76
1.01
1.26
0.00
0.65
1.46
1.22
1.83
0.99
1.56
0.40
1.28
0.83
1.34
0.54
1.25
0.92
1.00
0.79
0.79
1.44
1.00
2.24
2.50
2.24
1.25
1.49
0.84
1.42
1.00
1.25
1.42
1.35
0.93
0.40
1.39
DEPTH
7.2
2.2
13.9
15.5
3.0
16.2
14.4
5.7
6.1
9.1
17.2
8.7
17.9
12.3
7.4
7.0
17.1
8.8
6.0
19.1
14.3
4.7
8.6
6.0
14.6
4.9
19.1
9.9
16.1
4.6
4.9
16.1
14.0
4.2
5.9
5.4
15.6
11.1
15.4
16.4
4.9
8.1
7.5
14.1
11.1
16.0
5.5
7.3
3.1
6.0
Patient #
Infectious Disease
Age
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
68
41
59
55
45
78
75
67
65
71
67
66
70
71
44
46
73
54
43
56
67
67
75
77
62
61
72
74
54
61
73
49
48
69
72
76
62
58
46
62
63
66
64
55
64
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
49
72
49
70
70
70
58
60
70
67
67
54
75
69
64

Purchase answer to see full
attachment

Are you having trouble with the above assignment or one similar?

To date, 239 students have ordered this same assignment from us and received 100% original work. We can do the same for you!

We offers 100% original papers that are written from scratch.We also have a team of editors who check each paper for plagiarism before it is sent to you.

Click this “order now” button to see free Cost Breakdown!