Statistical Analysis Report Worksheet

User Generated

fcelat

Mathematics

Description

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 (attached) of the data that contains the following information:

  • Client number
  • Infection disease status
  • Age of the patient

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:

  1. Brief overview of the scenario and variables in the data set
  2. Discussion, calculation, and interpretation of the mean, median, mode, range, standard deviation, and variance
  3. Discussion, construction, and interpretation of the 95% confidence interval
  4. Explanation of the full hypothesis test
  5. Conclusion

The calculations should be performed in your spreadsheet that you will also submit to your manager. You can find additional information on what to add to your PowerPoint presentation in this Word document (attached). Use the questions in the worksheet as your guide for the contents of your presentation.

For your final deliverable, submit your PowerPoint presentation and the Excel workbook showing your work.

MUST MEET THE FOLLOWING REQUIREMENTS!


All problems are solved correctly.

Complete and detailed steps are provided to explain how to solve the problem.

Explanations demonstrate a mastery of understanding of the statistical concepts and terminology.

All variables, equations, and expressions are properly formatted.

Unformatted Attachment Preview

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 58 75 67 65 71 67 66 70 71 44 46 73 54 43 56 67 67 75 57 62 61 72 74 54 61 73 49 48 69 52 46 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 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 o Median o Mode o 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 ttest? 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 pvalue 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 4. 5. 6. 7.
Purchase answer to see full attachment
Explanation & Answer:
1 Worksheet
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Patient #
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

Infectious Disease
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
68
41
59
55
45
58
75
67
65
71
67
66
70
71
44
46
73
54
43
56
67
67
75
57
62
61
72
74
54
61
73
49
48
69
52
46
62
58
46
62
63
66
64

44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Mean
Median
Mode
Mid-Range
Range
Variance
Standard deviation
Confidence interval
Upper C.I
Lower C.i
Left-tailed test

Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes

55
64
49
72
49
70
70
70
58
60
70
67
67
54
75
69
64
61
64
67
17
34
88.20972222
9.3920031
64.3365046774634
59.0401619892032
2.955320644


STATISTICAL ANALYSIS REPORT
Name
Course
University

Introduction
• The NCLEX Memorial Hospital’s Infectious Diseases Unit has noticed an
increase in the number of patients admitted with a particular disease. I
believe that their age plays a critical role in the diagnosis and treatment of
the disease.

• With the help of my manager, I aim to use statistical analysis to gain a
better understanding of their age.
...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags