An elementary school determines that 90% of parents whose children are enrolled

Question

An elementary school determines that 90% of parents whose children are enrolled in the Gifted & Talented Program complete and return the program evaluation survey at the end of the school year. At the end of the 2005-2006 school year, the school mailed 45 surveys to the parents. Using the BINOMDIST function in Excel, which Excel statement will find the probability that at most 40 surveys are completed and returned to the school?

=BINOMDIST(40,45,0.9,FALSE)

=BINOMDIST(40,45,0.9,TRUE)

Neither statement will return the correct probability.

=BINOMDIST(40,45,0.9,FALSE)

=BINOMDIST(40,45,0.9,TRUE)

Neither statement will return the correct probability.

Explanation / Answer

An elementary school determines that 90% of parents whose children are enrolled in the Gifted & Talented Program complete and return the program evaluation survey at the end of the school year. At the end of the 2005-2006 school year, the school mailed 45 surveys to the parents. Using the BINOMDIST function in Excel, which Excel statement will find the probability that at most 40 surveys are completed and returned to the school?

=BINOMDIST(40,45,0.9,FALSE)

=BINOMDIST(40,45,0.9,TRUE)

Neither statement will return the correct probability.

=BINOMDIST(40,45,0.9,FALSE)

=BINOMDIST(40,45,0.9,TRUE)

Neither statement will return the correct probability.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.