Competency
Apply the normal distribution, standard normal distribution, and central limit theorem.
Project Deliverable tie to Competency
In module 02, you will summarize graphical and numerical methods to represent quantitative data. This includes utilizing the central limit theorem to calculate probabilities for real-world problems. It will also require you to analyze the standard normal distribution to identify z-values and the area under the curve. You will illustrate how to find probabilities, proportions, and percents by using Excel formulas. You will also demonstrate how to identify the z-score given a probability. These concepts allow you to make predictions and analyze the data provided.
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
Your boss at RAS Direct has some problems that need to be solved to help with projects they are attempting to start. Your job is to solve the problems and explain the methods to your boss. The Excel Workbook is provided below.
In your submission, include the Excel formulas to find these calculations. Your boss must know the method so they can include the answers in a presentation they are providing later in the week.
Instructions
The Excel Workbook contains four tabs. The first tab contains instructions. The next three tabs contain several questions for you to answer. Ensure that you are completely answering all questions with explanations, and your work is shown in Excel when needed.
Submission Requirements
· You must submit the Workbook with the completed calculations, answers, and analysis.