# Statistical Analysis Report item options

Description

Don't use plagiarized sources. Get Your Custom Essay on
Statistical Analysis Report item options
Just from \$13/Page

Assignment Content
1.
Competencies
o
o
o
o
o
o
Describe the data using the measures of central tendency and measures of variability.
Apply the normal distribution, standard normal distribution, and central limit theorem.
Develop a confidence interval for a population parameter.
Evaluate hypothesis tests for population parameters from one population.
Evaluate hypothesis tests for population parameters from two populations.
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.
Instructions
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
o Client number
o Infection disease status
o Age of the patient
Deliverable 7 – Statistical Analysis Report.xlsx
You are to put together a PowerPoint presentation that explains the analysis of your findings
which you will submit to your manager. The presentation should contain all components of your
findings. For review, the components of the report should include:
o
o
o
o
o
Brief overview of the scenario and variables in the data set
Discussion, calculation, and interpretation of the mean, median, mode, range, standard
deviation, and variance
Discussion, construction, and interpretation of the 95% confidence interval
Explanation of the full hypothesis test
Conclusion
The calculations should be performed in your spreadsheet that you will also submit to your
in this Word document.
Deliverable 7 – PowerPoint Instructions.docx
Use the questions in the Word document as your guide for the contents of your presentation.
For your final deliverable, submit your PowerPoint presentation and the Excel workbook
Patient #
Infectious Disease
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
Age
70
70
59
60
83
60
70
85
60
68
71
60
69
71
82
61
69
71
61
71
61
72
61
73
62
73
63
73
64
75
64
76
64
77
64
77
66
81
66
66
67
67
67
68
68
*Note: Refer to the Word document in th
Slide 6: Find the following statistical calcu
Age Calculations
Mean
Median
Mode
Midrange
Range
Variance
Standard Deviation
Maximum
Minimum
Slide 8: Construct a 95%
σ is unknown.
Critical Value
Margin of Error
Lower Limit
Upper Limit
Slide 9, 10, 11: Perform the following hyp
infectious diseases is less than 65 years o
Test Statistic
Critical Value
P-value
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
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
41
43
43
44
44
45
48
48
49
50
50
51
53
55
55
55
56
57
57
57
58
58
59
59
59
fer to the Word document in the deliverable instructions for a breakdown of requirements for each slide.
nd the following statistical calculations. In your PPT, include your interpretation of the calculations and the correct units.
95% confidence interval for the population mean ages of the patients. Assume that your data is normally distributed and
Perform the following hypothesis test based on the claim that the average age of all patients admitted to the hospital with
diseases is less than 65 years of age.
lly distributed and
he hospital with
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 70 patients that have the infectious disease with ages ranging from 42
years of age to 84 years of age for NCLEX Memorial Hospital.
Requirements:
1) Answer the questions below in a PowerPoint presentation.
2) Include the summary calculations and the formulas in your slides either
symbolically or from Excel. Do not round your results.
Submit both the PowerPoint and Excel files.
PowerPoint Presentation Requirements
Slide 1
Title Slide
Title
Slide 2
Provide a brief overview of the scenario you are given above and the data set
Overview
that you will be analyzing.
Slide 3
Classify the variables in your data set.
Classification • 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)
Slide 4
Measures of
Center
What are the measures of center and why are they important? Describe each
Slide 5
Measures of
Variation
What are the measures of variation and why are they important? Describe
have.
Slide 6
Calculations
Show your results for the following calculations. Include formulas used in
Excel. Interpret your results in the context of the scenario and include units of
measurement for each.
• Mean
• Median
• Mode
• Mid-range
• Range
• Variance
• Standard Deviation
Slide 7
Confidence
Intervals
• What are confidence intervals?
• What is a point estimate?
• What is the best point estimate for a population mean? Explain.
• Why do we need confidence intervals?
Slide 8
Confidence
Intervals
Construct a 95% confidence interval for the population mean ages of the
patients. Assume that your data is normally distributed and σ is unknown.
Show results for the following calculations in constructing the confidence
interval. Include formulas used in Excel. Interpret the confidence interval.
• Critical Value
• Margin of Error
• Upper and Lower Bounds
Slide 9
Hypothesis
Testing
Perform the following hypothesis test based on the claim that the average age
of all patients admitted to the hospital with infectious diseases is less than 65
years of age.
Write the null and alternative hypothesis symbolically and include the following
• Which hypothesis is the claim?
• Is the test two-tailed, left-tailed, or right-tailed? Explain
• Which test statistic will you use for your hypothesis test, z-test or ttest? Explain.
Slide 10
Hypothesis
Testing
Continue the hypothesis test based on the claim that the average age of all
patients admitted to the hospital with infectious diseases is less than 65 years
of age.
Show your results and formulas used for the following calculations:
• Test Statistic
• Critical Value
• P-value
Slide 11
Hypothesis
Testing
Complete the hypothesis test by explaining the following:
• Decision to reject the null hypothesis or to not reject the null
hypothesis.
• Explain your decision using the critical value method.
• Explain your reasoning using the P-value method.
• Restate your conclusion in non-technical terms.
Slide 12
Conclusion
Conclude by recapping your ideas by summarizing the information presented
in context of the scenario.
• Include the mean, standard deviation, confidence interval with
interpretation, and result of the hypothesis test.
• What conclusions, if any, do you believe we can draw as a result of
• 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?