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:

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

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 presentation and the spreadsheet. Do not submit your Word document.

Grading Rubric

FFCBA01234Not SubmittedNo PassCompetenceProficiencyMasteryNot SubmittedDid not correctly explain the scenario.Summarized the scenario.Fully explained the scenario.Fully explained the scenario and explanation of data provided.Not SubmittedNo spreadsheet submitted. Very few steps provided to explain how to calculate measures of center and variation or several errors in calculations..Spreadsheet included. Fairly complete and correct steps are provided to explain how to calculate the measures of center and variation.Spreadsheet included. Mostly complete and correct steps are provided to explain how to calculate the measures of center and variation.Spreadsheet included. Complete and correct steps are provided to explain how to calculate the measures of center and variation.Not SubmittedConfidence interval is incorrect and explanations lack comprehension.Explanations demonstrate a basic understanding of the confidence interval but some conceptual errors may be present or significant errors in calculations are present.Explanations demonstrate a proficient understanding of the confidence interval with only minor errors in calculations.Confidence Interval is correctly calculated and explanations demonstrate a mastery of understanding.Not SubmittedExplanations generally lack a basic understanding of fully performing a hypothesis test.Contents are basic when explaining a hypothesis test. A few key steps or components may be missing. Rounding present.Explanations are basic when explaining a hypothesis test. A few key steps or components may be incorrectly calculated.Correct hypothesis test concepts and calculations, steps provided within all explanations.Not SubmittedNo interpretation of conclusions provided.Interpretation of conclusions is present.Moderately detailed interpretation of conclusions.Conclusions are fully explained.