Description

Don't use plagiarized sources. Get Your Custom Essay on

Statistical Analysis Report item options

Just from $13/Page

Assignment Content

1.

Competencies

o

o

o

o

o

o

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

o Client number

o Infection disease status

o 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:

o

o

o

o

o

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.

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

70

70

59

60

83

60

70

85

60

68

71

60

69

71

82

61

69

71

61

71

61

72

61

73

62

73

63

73

64

75

64

76

64

77

64

77

66

81

66

66

67

67

67

68

68

*Note: Refer to the Word document in th

Slide 6: Find the following statistical calcu

Age Calculations

Mean

Median

Mode

Midrange

Range

Variance

Standard Deviation

Maximum

Minimum

Slide 8: Construct a 95%

σ is unknown.

Critical Value

Margin of Error

Lower Limit

Upper Limit

Slide 9, 10, 11: Perform the following hyp

infectious diseases is less than 65 years o

Test Statistic

Critical Value

P-value

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

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

41

43

43

44

44

45

48

48

49

50

50

51

53

55

55

55

56

57

57

57

58

58

59

59

59

fer to the Word document in the deliverable instructions for a breakdown of requirements for each slide.

nd the following statistical calculations. In your PPT, include your interpretation of the calculations and the correct units.

Formulas/Answers

95% confidence interval for the population mean ages of the patients. Assume that your data is normally distributed and

Perform the following hypothesis test based on the claim that the average age of all patients admitted to the hospital with

diseases is less than 65 years of age.

lly distributed and

he hospital with

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

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

Measures of

Center

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

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

Slide 5

Measures of

Variation

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

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

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 65

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 65 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?

Purchase answer to see full

attachment