# MC 621 UIC NCLEX Memorial Hospital Statistical Quantitative Analysis Report

Patient #Infectious Disease

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Age

69

41

57

55

45

59

71

71

72

67

60

65

73

72

42

45

65

47

44

51

71

66

84

56

61

59

68

73

50

55

77

57

47

71

58

49

65

60

44

61

57

63

61

60

62

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

55

66

50

77

66

66

65

57

69

59

70

53

76

74

68

55

61

81

43

67

Deliverable 07 Worksheet

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 65 patients that have the infectious disease with ages ranging from

41 years of age to 84 years of age for NCLEX Memorial Hospital.

Requirements:

1) Answer the questions below in a PowerPoint presentation.

2) Include the summary calculations and the formulas in your slides either symbolically or

from Excel. Do not round your results.

3) Show calculations in your Excel spreadsheet.

Submit both the PowerPoint and Excel files.

PowerPoint Presentation Requirements

Slide 1

Title Slide

Title

Slide 2

Provide a brief overview of the scenario you are given above and the data set

Overview

that you will be analyzing.

Slide 3

Classify the variables in your data set.

Classification • Which variables are quantitative/qualitative?

• Which variables are discrete/continuous?

• Describe the level of measurement for each variable included in the data

set (nominal, ordinal, interval, ratio)

Slide 4

What are the measures of center and why are they important? Describe each

Measures of

Center

Slide 5

Measures of

Variation

individually and list any advantages or disadvantages that each may have.

Slide 6

Calculations

Show your results for the following calculations. Include formulas used in

Excel. Interpret your results in the context of the scenario and include units

of measurement for each.

• Mean

• Median

• Mode

• Mid-range

• Range

• Variance

• Standard Deviation

Slide 7

Confidence

Intervals

Show your responses for the follow questions:

• What are confidence intervals?

• What is a point estimate?

• What is the best point estimate for a population mean? Explain.

• Why do we need confidence intervals?

Slide 8

Confidence

Intervals

Construct a 95% confidence interval for the population mean ages of the

patients. Assume that your data is normally distributed and σ is unknown.

What are the measures of variation and why are they important? Describe

each individually and list any advantages or disadvantages that each may

have.

Show results for the following calculations in constructing the confidence

interval. Include formulas used in Excel. Interpret the confidence interval.

• Critical Value

• Margin of Error

• Upper and Lower Bounds

Slide 9

Hypothesis

Testing

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 64 years of age.

Write the null and alternative hypothesis symbolically and include the

following additional information:

• Which hypothesis is the claim?

• Is the test two-tailed, left-tailed, or right-tailed? Explain

• Which test statistic will you use for your hypothesis test, z-test or ttest? Explain.

Slide 10

Hypothesis

Testing

Continue the hypothesis test based on the claim that the average age of all

patients admitted to the hospital with infectious diseases is less than 64

years of age.

Show your results and formulas used for the following calculations:

• Test Statistic

• Critical Value

• P-value

Slide 11

Hypothesis

Testing

Complete the hypothesis test by explaining the following:

• Decision to reject the null hypothesis or to not reject the null

hypothesis.

• Explain your decision using the critical value method.

• Explain your reasoning using the P-value method.

• Restate your conclusion in non-technical terms.

Slide 12

Conclusion

Conclude by recapping your ideas by summarizing the information

presented in context of the scenario.

• Include the mean, standard deviation, confidence interval with

interpretation, and result of the hypothesis test.

• What conclusions, if any, do you believe we can draw as a result of

your study?

• What did you learn from the project about the population based on

this sample?

• What did you learn about the specific statistical tests you conducted?

## We've got everything to become your favourite writing service

### Money back guarantee

Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.

### Confidentiality

We don’t share your private information with anyone. What happens on our website stays on our website.

### Our service is legit

We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.

### Get a plagiarism-free paper

We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.

### We can help with urgent tasks

Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.

### Pay a fair price

Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.