Question

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

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 manager. You can find additional information on what to add to your PowerPoint presentation in this Word document. 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.

Patient #	Infectious Disease	Age
1	Yes	67
2	Yes	38
3	Yes	58
4	Yes	52
5	Yes	46
6	Yes	61
7	Yes	74
8	Yes	69
9	Yes	67
10	Yes	70
11	Yes	65
12	Yes	69
13	Yes	72
14	Yes	69
15	Yes	45
16	Yes	49
17	Yes	72
18	Yes	52
19	Yes	46
20	Yes	57
21	Yes	70
22	Yes	67
23	Yes	77
24	Yes	59
25	Yes	59
26	Yes	61
27	Yes	72
28	Yes	71
29	Yes	52
30	Yes	58
31	Yes	73
32	Yes	52
33	Yes	47
34	Yes	68
35	Yes	55
36	Yes	45
37	Yes	59
38	Yes	58
39	Yes	47
40	Yes	62
41	Yes	62
42	Yes	64
43	Yes	62
44	Yes	56
45	Yes	62
46	Yes	52
47	Yes	70
48	Yes	51
49	Yes	70
50	Yes	69
51	Yes	69
52	Yes	60
53	Yes	57
54	Yes	68
55	Yes	64
56	Yes	64
57	Yes	56
58	Yes	72
59	Yes	70
60	Yes	67

Answer 1

Descriptive Statistics: Age

Variable N Mean SE Mean StDev Variance CoefVar Minimum Q1
Age 60 61.25 1.17 9.07 82.26 14.81 38.00 55.25

  
Variable Median Maximum IQR Mode Skewness Kurtosis
Age 62.00 77.00 13.75 52, 69, 70 -0.49 -0.60

Hence Median>Mean and it is not unimodal distribution. The distribution is negatively skewed.

Hence the above plot we observe that the data do not follow normal distribution.

One-Sample T: Age

Variable N Mean StDev SE Mean 95% CI
Age 60 61.25 9.07 1.17 (58.91, 63.59)