SOLUTION: I don't understand how to solve this problem in excel. 100 patients, standard dev. 6 minutes, mean is 25 minutes. How many patients will be seen in 20, 25 and 30 minutes.

Algebra ->  Probability-and-statistics -> SOLUTION: I don't understand how to solve this problem in excel. 100 patients, standard dev. 6 minutes, mean is 25 minutes. How many patients will be seen in 20, 25 and 30 minutes.      Log On


   

Question 353214: I don't understand how to solve this problem in excel.
100 patients, standard dev. 6 minutes, mean is 25 minutes. How many patients will be seen in 20, 25 and 30 minutes.
Answer by Fombitz(32388) About Me  (Show Source):
You can put this solution on YOUR website!
x=20,25,30
mu=25
sigma=6
Calculate the zscore for each x.
Then find the probability.
Multiply the probability by 100 to get the patients seen.
I'll do one, you do the others.
z=%28x-mu%29%2Fsigma=%2820-25%29%2F6=-5%2F6=+-0.833
P%28-0.833%29=0.202328
N=100%2A0.202328=20.2
or in EXCEL it's "=100*NORMDIST(20,25,6,TRUE)"
.
.
20 patients will be seen within 20 minutes.
.
.
.
Continue in the same manner.