1. RANDOM SELECTION SBP DATA SET: NORMAL DISTRIBUTION

   1. Click on the tab “Random Selection SBP” at the bottom of the screen.

   2. For this problem, we are going to find the probability of selecting a value of SBP (x) or less if our population is normally distributed with a population mean (µ) of 118 and a standard deviation (σ) of 12.

2. The first value of x (132) for SBP is in Row 2. Go to Column B, which is titled Probability of Randomly Selecting value of x or Less for SBP on Normal Distribution.

12. In cell B2, enter the following formula “ =NORMDIST(A2,118,12,TRUE)”. We are asking Excel to tell us the probability of selecting a subject with a SBP of 132 or less from a normally distributed population with a mean SBP of 118 and a standard deviation of 12. By indicating “TRUE”, we also told Excel we want the probability of not just randomly selecting a subject with the SBP score of 132 but also of randomly selecting subjects with SBP scores less than 132.

21. To calculate this same formula for all values of x, place your cursor at the lower right-hand corner of cell B2 and click. When you put your cursor in the lower right-hand corner of the cell B2 and click, the appearance of your cursor will change from ”       “   to     “ + ”.  When it changes to “ + ”, drag the cursor all the way down to cell B21. At this point, you should notice the probability of selecting the specific value of x or less is automatically calculated for all values of x.

DETAILED ASSIGNMENT

20200924124151assignment_instructions 20200924124151biostat_assignment