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 the

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
Age of the patient

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.

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 #	Age
1	83
2	72
3	70
4	65
5	60	Age Calculations	Formulas/Answers
6	67	Mean
7	60	Median
8	44	Mode
9	72
10	81
11	66
12	75
13	66
14	48
15	55
16	62
17	76	Midrange
18	65	Range
19	48	Variance
20	59	Standard Deviation
21	65
22	60	Maximum
23	58	Minimum
24	63
25	44
26	57
27	77
28	69
29	70
30	71	Critical Value
31	50	Margin of Error
32	68	Lower Limit
33	53	Upper Limit
34	77
35	43
36	60
37	72
38	61
39	66
40	58
41	59	Test Statistic
42	51	Critical Value
43	62	P-value
44	68
45	73
46	49
47	55
48	40
49	45
50	57
51	67
52	50
53	43
54	73
55	67
56	58
57	65
58	57
59	70
60	87
61	58
62	72
63	73
64	68
65	62
66	69
67	62
68	56
69	82
70	55

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.

Deliverable 07 Worksheet

Scenario

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 40 years of age to 87 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

Title Slide

Slide 2

Overview

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

Slide 3

Classification

Classify the variables in your data set.

· 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. Include units of measurement for each.

· Mean

· Median

· Mode

· Mid-range

· Range

· Variance

· Standard Deviation

Slide 7

Confidence Intervals

Show your responses for the following 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 t-test? 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?

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 the

Data and Calculations

Deliverable 07 Worksheet

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A