Part 2: Binomial DistributionA local college basketball team will play a 30-game schedule this season. Assume that the team has a probability of 0.6 of winning each game. Type the labels "Binomial"in cell C16 and "Distribution"in cell D16. Type "n" in E16, 30 in F16, "p" in G16, and 0.6 in H16.Starting with the first probability statement in cell C18 and the result in cell D18, continue in columns C and D to find the following probabilities. The variable x represents the number of wins. You may use functions and combinations of functions of the form binom.dist, (binomdistin earlier Excel), and binom.dist.rangedepending on your version of Excel and your personal preference. Please use the help function if you're not sure how to use a particular function. Since the binomial distribution is discrete, you'll have to pay special attention as to whether endpoints should be included. Use cell references F16 and H16 whenever possible.

Round your answers to four decimals.

oP(x = 21)

oP(x 16)

oP(x > 10)

oP(15 x 23)

oP(15 < x < 23)

Part 3: Normal DistributionScores on a national statistics exam are normally distributed with a mean of 74 and a standard deviation of 12. Type the labels "Normal" in cell C24 and "Distribution" in cell D24. Type "mean" in E24, 74 in F24, "standard deviation" in G24, and 12 in H24.Starting with the first probability statement in cell C26and the result in cell D26 continue in columns C and D to find the following probabilities. Assume that one person is selected at random from the population. You may use functions and combinations of functions of the form norm.dist, (normdistin earlier Excel), norm.inv, and (norminvin earlier Excel) dependingon your version of Excel. Please use the help function if you're not sure how to use a particular function. Use cell references F24 and H24 whenever possible.

Round your answers to four decimals.

oP(x < 80)

oP(x > 65)

oP(55 < x < 85)

o x2 such that P(x

o x2 such that P(x > xc) = 0.05