In: Statistics and Probability
Seventy percent of the students applying to a university are accepted. Using the binomial probability tables or Excel, what is the probability that among the next 12 applicants:
Scores on a recent national statistics exam were normally distributed with a mean of 90 and a standard deviation of 5.
[ The above probability is obtained using the function
=1-BINOMDIST(5,12,0.7,TRUE) in Excel 07 which gives the value
0.961399 . ]
[ The above probability is obtained using the function
=BINOMDIST(5,12,0.7,FALSE) in Excel 07 which gives the value
0.16779 . ]
[ The above probability is obtained using the function
=BINOMDIST(4,12,0.7,FALSE) in Excel 07 which gives the value
0.16779 . ]
[ The above probability is obtained using the function
=1-BINOMDIST(6,12,0.7,TRUE) in Excel 07 which gives the value
0.882151 . ]
.
.
.
[ The above probability is obtained using the function
=1-NORMDIST(85,90,5,TRUE) in Excel 07 which gives the value
0.841345 . ]
[ The above probability is obtained using the function
=NORMDIST(92,90,5,TRUE)-NORMDIST(89,90,5,TRUE) in Excel 07 which
gives the value 0.841345 . ]
[ The above value is obtained using the function
=NORMINV(0.975,90,5) in Excel 07 which gives the value 99.79982 .
]