Competency Apply the normal distribution, standard normal distribution, and central limit theorem.   Scenario Frank has only had a brief introduction to statistics when he was in high school 12 years ago, and that did not cover inferential statistics. He is not confident in his ability to answer some of the problems posed in the course. As Frank's tutor, you need to provide Frank with guidance and instruction on a spreadsheet he has partially filled out. Your job is to help him understand and comprehend the material. You should not simply be providing him with an answer as this will not help when it comes time to take the test. Instead, you will be providing a step-by-step breakdown of the problems including an explanation on why you did each step and using proper terminology.   To complete this assignment, you must first download the spreadsheet, and then complete it by including the following items on the spreadsheet: Incorrect Answers - Correct any wrong answers. You must also explain the error performed in the problem in your own words. Partially Finished Work - Complete any partially completed work. Make sure to provide step-by-step instructions including explanations. Blank Questions - Show how to complete any blank questions by providing step-by-step instructions including explanations. Your step-by-step breakdown of the problems, including explanations and calculations performed, should be present within the Excel spreadsheet provided.

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 numberInfection disease statusAge 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 setDiscussion, calculation, and interpretation of the mean, median, mode, range, standard deviation, and varianceDiscussion, construction, and interpretation of the 95% confidence intervalExplanation of the full hypothesis testConclusion 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 the word document below. Use the questions in the worksheet as your guide for the contents of your presentation. Finally, submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document.