prof maurice

profilecwwmlrchall06

 

Option 2 Scenario

G310 Advanced Statistics and Analytics – Option 2

Introduction:

As a healthcare professional, you will work to improve and maintain the health of individuals, families, and communities in various settings.  Basic statistical analysis can be used to gain an understanding of current problems.  Understanding the current situation is the first step in discovering where an opportunity for improvement exists.  This course project will assist you in applying basic statistical principles to a fictional scenario in order to impact the health and wellbeing of the clients being served.   

This assignment will be completed in phases throughout the quarter.  As you gain additional knowledge through the didactic portion of this course, you will be able to apply your new knowledge to this project.  You will receive formative feedback from your instructor on each submission.  The final project will be due on week 10.  

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. Remember this assignment will be completed over the duration of the course.

 

 

 

 

 

 

Review each scenario and data set carefully and choose which scenario you would like to work with. Begin Phase 1 of your analysis by including the following information:

 

  • Option 2 allows you to analyze the ages of infectious disease patients at NCLEX Memorial Hospital. 


1.      Introduce your scenario and data set.

o    Provide a brief overview of the scenario you are given above and the data set that you will be analyzing.

o    Describe the variables in your data set.

§  Are the variables quantitative or qualitative? Explain.

§  Are the variables discrete or continuous? Explain

 

2.      Calculate the measures of center and measures of variation. (Calculate these using Excel and then copy the results from Excel into your Word Document) 30 Points

 

    • Mean
    • Median
    • Mode
    • Range
    • Variance
    • Standard Deviation

       . 3. Conclusion

                Recap your ideas by summarizing the information presented.

 

 

 

 

 

 

Patient #

Infectious Disease

Age

  

1

Yes

69

  

2

Yes

35

  

3

Yes

60

  

4

Yes

55

  

5

Yes

49

  

6

Yes

60

  

7

Yes

72

  

8

Yes

70

  

9

Yes

70

  

10

Yes

73

  

11

Yes

68

  

12

Yes

72

  

13

Yes

74

  

14

Yes

69

  

15

Yes

46

  

16

Yes

48

  

17

Yes

70

  

18

Yes

55

  

19

Yes

49

  

20

Yes

60

  

21

Yes

72

  

22

Yes

70

  

23

Yes

76

  

24

Yes

56

  

25

Yes

59

  

26

Yes

64

  

27

Yes

71

  

28

Yes

69

  

29

Yes

55

  

30

Yes

61

  

31

Yes

70

  

32

Yes

55

  

33

Yes

45

  

34

Yes

69

  

35

Yes

54

  

36

Yes

48

  

37

Yes

60

  

38

Yes

61

  

39

Yes

50

  

40

Yes

59

  

41

Yes

60

  

42

Yes

62

  

43

Yes

63

  

44

Yes

53

  

45

Yes

64

  

46

Yes

50

  

47

Yes

69

  

48

Yes

52

  

49

Yes

68

  

50

Yes

70

  

51

Yes

69

  

52

Yes

59

  

53

Yes

58

  

54

Yes

69

  

55

Yes

65

  

56

Yes

61

  

57

Yes

59

  

58

Yes

71

  

59

Yes

71

  

60

Yes

68

  
     
     
     
    • 9 years ago
    • 3
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      data_and_summary_stats.xlsx
    • attachment
      infectious_diseases_case_study.edited.docx