For this problem, you must use Excel to perform the necessary calculations. Below are the formulas and equations you wil

[answerhappygod]

For This Problem You Must Use Excel To Perform The Necessary Calculations Below Are The Formulas And Equations You Wil 1 (251.49 KiB) Viewed 17 times

For this problem, you must use Excel to perform the necessary calculations. Below are the formulas and equations you will need to use. If it is appropriate to use the binomial distribution, use the formula =binom.dist(number_s, trials probability, cumulative) to calculate the probability. In this formula, number s is the number of successful trials, trials is the total number of trials, probability is the probability for a single trial expressed as a decimal, and cumulative should be set as false. This will report the binomial distribution probability for a single outcome. You are tasked with reporting a cumulative probability If it is appropriate to use the normal approximation of the binomial distribution calculate Z using the correct equation from the option below, In Europe, 53% of the flowers of the Rewardless Orchid, Dactylorhiza sambucina are and then use either the formula =(1-(norm.dist(2,0,1,TRUE)) when calculating a right-tailed probability or the formula =(norm.dist(2,0,1,TRUE)) for a left-tailed probability Right-tailed tests find probabilities for X 2 observed while left-tailed tests find probabilities for X s observed Observed -- Observed - Pr[X2 Observed] = P2 > or Prts Observed) - 2 np(1-2) no(-p) yellow, whereas the remaining flowers are purple. For this problem, only use the normal approximation where it is appropriate. Use the binomial distribution where the normal approximation is inappropriate. If we took a random sample of a single individual from this population, what is the probability, reported as a percent, that is would be purple? t-ng 47 Determine the probability, reported as a decimal rounded to two decimal places, that if we took a random sample of 6 flowers, at least 4 would be yellow. 0.06 If we took a random sample of 260 individuals, what is the probability, reported as a decimal rounded to two decimal places, that 150 or more of the orchids are yellow?