Statistical Analysis Report Assignment Content Competencies Describe the data using the measures of central tendency and measures of variabi

Statistical Analysis Report Assignment Content

Competencies

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

Client number
Infection disease status
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:

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. 

Deliverable 7 – PowerPoint Instructions.docx

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

Patient # Infectious Disease Age

1 Yes 69

2 Yes 41

3 Yes 58

4 Yes 55

5 Yes 45

6 Yes 59

7 Yes 71

8 Yes 71

9 Yes 72

10 Yes 67

11 Yes 60

12 Yes 65

13 Yes 73

14 Yes 73

15 Yes 42

16 Yes 45

17 Yes 65

18 Yes 66

19 Yes 44

20 Yes 51

21 Yes 71

22 Yes 66

23 Yes 84

24 Yes 56

25 Yes 61

26 Yes 59

27 Yes 68

28 Yes 73

29 Yes 50

30 Yes 55

31 Yes 77

32 Yes 57

33 Yes 48

34 Yes 71

35 Yes 58

36 Yes 49

37 Yes 65

38 Yes 60

39 Yes 44

40 Yes 61

41 Yes 57

42 Yes 63

43 Yes 61

44 Yes 60

45 Yes 62

46 Yes 55

47 Yes 66

48 Yes 50

49 Yes 77

50 Yes 66

51 Yes 69

52 Yes 65

53 Yes 57

54 Yes 69

55 Yes 59

56 Yes 70

57 Yes 53

58 Yes 76

59 Yes 75

60 Yes 68

61 Yes 55

62 Yes 61

63 Yes 81

64 Yes 48

65 Yes 67