Overview
Competency
- Examine basic descriptive statistics and demonstrate results using calculated values and statistical charts.
- Demonstrate the use of the normal distribution, the standard normal distribution, and the central limit theorem for calculating areas under the normal curve and exploring these concepts in real life applications.
- Given a real-life application, develop a confidence interval for a population parameter and its interpretation.
- Formulate and evaluate hypothesis tests for population parameters based on sample statistics using both Critical Regions and P-values, and be able to state results in a non-technical way that can be understood by consumers of the data instead of statisticians.
- Determine and interpret the linear correlation coefficient, and use linear regression to find a best-fit line for a scatter plot of the data and make predictions.
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 spreadsheetLinks to an external site. 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:
- 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 documentLinks to an external site.. 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.
View Rubric
| Deliverable 7 | ||
|---|---|---|
| Criteria | Ratings | Pts |
| Slides 1-3 view longer description | 16 pts Excellent Slides 1-3: Provides a clear overview of the scenario and clearly identifies the variables of the data set and the level of measurement for each variable within the data set.12 pts Good Slides 1-3: Provides an adequate overview of the scenario and identifies the variables of the data set and the level of measurement for each variable within the data set.8 pts Average Slides 1-3: Partial attempt at creating an overview of the scenario, identifying the variables of the data set, and the level of measurement for each variable within the data set.4 pts Needs Improvement Slides 1-3: Little to no attempt at creating an overview of the scenario, identifying the variables of the data set, and the level of measurement for each variable within the data set.0 pts No Marks | / 16 pts |
Slides 4-6 view longer description | 16 pts Excellent Slides 4-6: Thoroughly answers the questions required for slides 4-5, correctly calculates the measures of center and measures of variation, and thoroughly interprets the results.12 pts Good Slides 4-6: Adequately answers the questions required for slides 4-5, correctly calculates the measures of center and measures of variation, and adequately interprets the results.8 pts Average Slides 4-6: Partial attempt at answering the questions required for slides 4-5, calculates the measures of center and measures of variation, and provides partial attempt at interpreting the results.4 pts Needs Improvement Slides 4-6: Little to no attempt at answering the questions required for slides 4-5, calculates the measures of center and measures of variation incorrectly, and provides little to no attempt at interpreting the results.0 pts No Marks | / 16 pts |
Slides 7-8 view longer description | 17 pts Excellent Slides 7-8: Provides thorough responses to the questions required for slides 7-8.12.75 pts Good Slides 7-8: Provides adequate responses to the questions required for slides 7-8.8.5 pts Average Slides 7-8: Partial attempt at providing responses to the questions required for slides 7-8.4.25 pts Needs Improvement Slides 7-8: Little to no attempt at providing responses to the questions required for slides 7-8.0 pts No Marks | / 17 pts |
Slides 9-11 view longer description | 17 pts Excellent Slides 9-11: Performs a hypothesis test and provides thorough responses to the questions required for slides 9-11.12.75 pts Good Slides 9-11: Performs a hypothesis test and provides adequate responses to the questions required for slides 9-11.8.5 pts Average Slides 9-11: Performs a hypothesis test and provides a partial attempt at responding to the questions required for slides 9-11.4.25 pts Needs Improvement Slides 9-11: Does not perform a hypothesis test and/or provides little to no attempt at responding to the questions required for slides 9-11.0 pts No Marks | / 17 pts |
Slide 12 view longer description | 17 pts Excellent Slide 12: Summary responses are clear, detailed, and thorough.12.75 pts Good Slide 12: Summary responses are adequate.8.5 pts Average Slide 12: Partial attempt at creating a summary slide.4.25 pts Needs Improvement Slide 12: Little to no attempt at creating a summary slide.0 pts No Marks | / 17 pts |
Excel Workbook view longer description | 17 pts Excellent All calculations are clearly organized and identified on a separate Excel workbook.12.75 pts Good Most calculations are clearly organized and identified on a separate Excel workbook.8.5 pts Average Some calculations are clearly organized and identified on a separate Excel workbook.4.25 pts Needs Improvement No calculations were organized and identified on a separate Excel workbook.0 pts No Marks | / 17 pts |
| Total Points: 0 |