Math W4

Using Excel to Determine Probabilities for Binomial Distributions

In this week’s assignment, we will learn how to use Excel to calculate probabilities for a binomial distribution.

· The resource to consult: Section 4.3 Binomial Distribution.

· Resource to consult: Section 5-2  Triola Stats.com es13 excel videos 

View video and then complete the following tasks in a blank Excel worksheet.  5-2 Using Excel to Compute Binomial Probabilities [03:48]

Consider the following situation. The Office of Student Affairs receives numerous appeals from students seeking reevaluation of their enrollment status. The office has observed that, on average, 30% of appeals are successful. Suppose the office has recently received 15 appeals.

· Calculate the probability that none of the appeals will be successful.

· Determine the probability that exactly three appeals will be successful.

· Find the probability that at least two appeals will be successful. At least two appeals means P(x≥2).

· Compute the probability that less than half of the appeals will be successful.  Less than half means P(x<8) or P(x≤7).

Save the completed worksheet as  W4_Assignment.xls