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.

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

Data and Calculations

Patient # Infectious Disease Age

1 Yes 70

2 Yes 43

3 Yes 59

4 Yes 58

5 Yes 43 Age Calculations Formulas/Answers

6 Yes 60 Mean

7 Yes 71 Median

8 Yes 71 Mode

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 Midrange

18 Yes 67 Range

19 Yes 44 Variance

20 Yes 51 Standard Deviation

21 Yes 71

22 Yes 66 Maximum

23 Yes 84 Minimum

24 Yes 56

25 Yes 61

26 Yes 59

27 Yes 68

28 Yes 73

29 Yes 50

30 Yes 55 Critical Value

31 Yes 77 Margin of Error

32 Yes 57 Lower Limit

33 Yes 48 Upper Limit

34 Yes 71

35 Yes 58

36 Yes 49

37 Yes 65

38 Yes 60

39 Yes 44

40 Yes 61

41 Yes 57 Test Statistic

42 Yes 63 Critical Value

43 Yes 61 P-value

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

66 Yes 59

67 Yes 83

68 Yes 70

69 Yes 68

70 Yes 82

Slide 6: Find the following statistical calculations. In your PPT, include your interpretation of the calculations and the correct units.

*Note: Refer to the Word document in the deliverable instructions for a breakdown of requirements for each slide.

Slide 8: Construct a 95% confidence interval for the population mean ages of the patients. Assume that your data is normally distributed and σ is unknown.

Slide 9, 10, 11: Perform the following hypothesis test based on the claim that the average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.

Data and Calculations

Patient # Infectious Disease Age

1 Yes 70

2 Yes 43

3 Yes 59

4 Yes 58

5 Yes 43 Age Calculations Formulas/Answers

6 Yes 60 Mean

7 Yes 71 Median

8 Yes 71 Mode

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 Midrange

18 Yes 67 Range

19 Yes 44 Variance

20 Yes 51 Standard Deviation

21 Yes 71

22 Yes 66 Maximum

23 Yes 84 Minimum

24 Yes 56

25 Yes 61

26 Yes 59

27 Yes 68

28 Yes 73

29 Yes 50

30 Yes 55 Critical Value

31 Yes 77 Margin of Error

32 Yes 57 Lower Limit

33 Yes 48 Upper Limit

34 Yes 71

35 Yes 58

36 Yes 49

37 Yes 65

38 Yes 60

39 Yes 44

40 Yes 61

41 Yes 57 Test Statistic

42 Yes 63 Critical Value

43 Yes 61 P-value

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

66 Yes 59

67 Yes 83

68 Yes 70

69 Yes 68

70 Yes 82

Slide 6: Find the following statistical calculations. In your PPT, include your interpretation of the calculations and the correct units.

*Note: Refer to the Word document in the deliverable instructions for a breakdown of requirements for each slide.

Slide 8: Construct a 95% confidence interval for the population mean ages of the patients. Assume that your data is normally distributed and σ is unknown.

Slide 9, 10, 11: Perform the following hypothesis test based on the claim that the average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.