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 .
]