Statistical Analysis Instructions
Statistical Analysis. 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 Deliverable_07_Data_ma.xlsxof the data that contains the following information:
 Client number
 Infection disease status
 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 Deliverable_07_Questions_ma.docxUse the questions in the worksheet as your guide for the contents of your presentation.
For your final deliverable, submit your presentation and the spreadsheet. Do not submit your Word document.
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 
Statistical Analysis 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.
Academic Writing
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: Statistical Analysis
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.
Requirements:
 Answer the questions below in a PowerPoint presentation.
 Include only the summary calculations in your slides (not formulas).
 Show calculations in your Excel spreadsheet (include formulas and do not round the numbers).
 Slide 1: Title
 Introduce your scenario and data set.
 Slide 2: Provide a brief overview of the scenario you are given above and the data set that you will be analyzing.

Slide 3: 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)
 Discuss the importance of the Measures of Center and the Measures of Variation.
 Slide 4: What are the measures of center and why are they important?
 Slide 5: What are the measures of variation and why are they important?

Slide 6: Calculate the measures of center and measures of variation. Interpret your results in context of the scenario.
 Mean
 Median
 Mode
 Midrange
 Range
 Variance
 Standard deviation

Slide 7: Discuss the importance of constructing confidence intervals for the population mean by answering these questions:
 What are confidence intervals?
 What is a point estimate?
 What is the best point estimate for the population mean? Explain.
 Why do we need confidence intervals?
 Slide 8: Construct a 95%confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown. Include a statement that correctly interprets the confidence interval in context of the scenario.
 Perform the following hypothesis test:

Original Claim:The average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.
 Test the claim using α = 0.05 and assume your data is normally distributed and σ is unknown.
 Answer the following:
 Slide 9: Write the null and alternative hypothesis symbolically and identify which hypothesis is the claim.
 Slide 9: Is the test twotailed, lefttailed, or righttailed? Explain.
 Slide 10: Which test statistic will you use for your hypothesis test; ztest or ttest? Explain.
 Slide 10: What is the value of the teststatistic? What is the pvalue? What is the critical value?

Slide 11: What is your decision; reject the null hypothesis, or do not reject the null hypothesis?
 Explain why you made your decision, including the results for your pvalue and the critical value.
 Slide 11: State the final conclusion in nontechnical terms.

Original Claim:The average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.

Slide 12: 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 results of the hypothesis test.
 What conclusions, if any, do you believe you 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?