Fill This Form To Receive Instant Help
Homework answers / question archive / Deliverable 7 Statistical Analysis Report Instructions You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit
Deliverable 7 Statistical Analysis Report
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:
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:
1. Brief overview of the scenario and variables in the data set
2. Discussion, calculation, and interpretation of the mean, median, mode, range, standard deviation, and variance
3. Discussion, construction, and interpretation of the 95% confidence interval
4. Explanation of the full hypothesis test
5. 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 worksheet 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.
Grading Rubric.
1. All problems are solved correctly.
2. Complete and detailed steps are provided to explain how to solve the problem.
3. Explanations demonstrate a mastery of understanding of the statistical concepts and terminology.
4. All variables, equations, and expressions are properly formatted.
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:
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 
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.

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.

Slide 7 Confidence Intervals 
Show your responses for the follow questions:

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.

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:

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:

Slide 11 Hypothesis Testing 
Complete the hypothesis test by explaining the following:

Slide 12 Conclusion 
Conclude by recapping your ideas by summarizing the information presented in context of the scenario.

Already member? Sign In
Purchased 3 times