Assume a mean of 75 mmhg and standard deviation of 5 mmhg is

Assume a mean of 75 mmhg and standard deviation of 5 mmhg is for diastolic blood pressure. Use the =NORMDIST( ) function to determine the following:

a.   The proportion of people who have diastolic blood pressure less than 76 mmhg

c.   The proportion of people who have diastolic blood pressure greater than 73 mmhg

Solution

Sol)

Given mean=75 and standard deviation=5

a)  The proportion of people who have diastolic blood pressure less than 76 mmhg

Sol) Using Excel function

=NORM.DIST(76,75,5,TRUE)

P(X<76) =0.579

B) The proportion of people who have diastolic blood pressure greater than 73 mmhg

Sol) P(X>73) = 1-P(X<73)

Using Excel function

=NORM.DIST(73,75,5,TRUE)

P(X<73) =0.3445

P(X>73) = 1-P(X<73) =1-0.3445 =0.656