You do some research and put together a spreadsheet Click for more options of the data that contains the following information:

User Generated

obool9092

Mathematics

Rasmussen University

Description

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 Click for more options 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 Click for more options . 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. Do not submit your Word document.

Unformatted Attachment Preview

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 69 41 57 55 45 59 71 71 72 67 60 65 73 72 42 45 65 47 44 51 71 66 84 56 61 59 68 73 50 55 77 57 47 71 58 49 65 60 44 61 57 63 61 60 62 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 55 66 50 77 66 66 65 57 69 59 70 53 76 74 68 55 61 81 43 67
Purchase answer to see full attachment
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. Please let me know if you have any questions or need revisions.

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
69
41
57
55
45
59
71
71
72
67
60
65
73
72
42
45
65
47
44
51
71
66
84
56
61
59
68
73
50
55
77
57
47
71
58
49
65
60
44
61
57
63
61
60
62

Mean
Median
Mode
Midrange
Range
Variance
Standard Deviation

61,2923
61,0000
57,0000
62,5000
43,0000
104,3976
10,2175

46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65

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

55
66
50
77
66
66
65
57
69
59
70
53
76
74
68
55
61
81
43
67

Slide 8: Confidence Interval
n
Mean
standard deviation
alpha
α/2
1 - α/2
t critical
Error, E
Upper boundary
Lower Boundary

65
61
10,2175
5%
0,025
0,975
1,997729654
2,531776051
64
59

std dev
mean

10,217...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags