Assignment Content
Competency
Describe the data using the measures of central tendency and measures of variability.
Apply the normal distribution, standard normal distribution, and central limit theorem.
Develop a confidence interval for a population parameter.
Evaluate hypothesis tests for population parameters from one population.
Evaluate hypothesis tests for population parameters from two populations.
Determine the linear correlation and regression equation between two variables to make predictions for the dependent variable.
Student Success Criteria
View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.
Scenario
You are currently working at Bayes 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 and weights 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 statistics of these patients.
You do some research and put together the attached spreadsheet of the data that contains the following variables
Patient number
Infection disease status
Age of the patient
Weight of the patient in pounds
The Excel spreadsheet contains eight tabs. The first tab, labeled “data”, requires you to calculate all measures of center and variation for the age variable using the correct Excel formulas. The next seven tabs contain questions for you to complete.
You must submit the spreadsheet with the completed calculations, answers, and analysis. Ensure that you are completely answering all questions with steps shown, explanations, and correct formatting.
