Need Assistance with Assignment IS Del7

I’m attaching assignment instructions and grading rubric. Along with the speed sheet to complete the assignment. 

I’ve posted a budget if you feel it needs to be changed please talk to me prior to completing the assignment. 

Thanks!

2

>Names

#

2 Yes

1

Yes

4 Yes

5 Yes

6 Yes

7 Yes

Yes 71

9 Yes

Yes

Yes

Yes

Yes

Yes 72

Yes

Yes 45

Yes 65

Yes

Yes

Yes

Yes 71

Yes

Yes

Yes

Yes

Yes 59

Yes

Yes 73

Yes

Yes 55

Yes

Yes

Yes 47

Yes 71

Yes

Yes

Yes 65

Yes 60

Yes 44

Yes 61

Yes 57

42 Yes

Yes 61

44 Yes 60
45 Yes

Yes 55

47 Yes 66

Yes 50

49 Yes 77
50 Yes 66
51 Yes 66

Yes 65

Yes 57

Yes

55 Yes 59
56 Yes

57 Yes 53
58 Yes

59 Yes

60 Yes 68
61 Yes 55
62 Yes 61
63 Yes

Yes 43

65 Yes 67

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

  

Deliverable 7 – Statistical Analysis Report

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:

· 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

 

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