Biostatistics assignment
-
RANDOM SELECTION SBP DATA SET: NORMAL DISTRIBUTION
-
Click on the tab “Random Selection SBP” at the bottom of the screen.
-
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.
-
-
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.
-
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.
-
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