Q2: Can you solve all the parts to this question with clearly showing which answer is for what part, and PLEASE follow the rounding guidlines for each part and Exell
![For this problem, you must use Excel to perform the necessary calculations. Below are the<br>formulas and equations you will need to use.<br>If it is appropriate to use the binomial distribution, use the formula<br>=binom.dist(number_s,trials,probability,cumulative) to calculate the<br>probability. In this formula, number_s is the number of sucessful<br>trials, trials is the total number of trials, probability is the probability for a<br>single trial expressed as a decimal, and cumulative should be set as false.<br>This will report the binomial distribution probability for a single outcome. You<br>are tasked with reporting a cumulative probability.<br>If it is appropriate to use the normal approximation of the binomial<br>distribution, calculate Z using the correct equation from the option below,<br>and then use either the formula =(1-(norm.dist(Z,0,1,TRUE))) when<br>calculating a right-tailed probability or the formula ={norm.dist(Z,0,1,TRUE))<br>for a left-tailed probability.<br>In Europe, 53% of the<br>Right-tailed tests find probabilities for X 2 observed while left-tailed tests find<br>probabilities for X s observed<br>1<br>Observed<br>- np<br>Observed +<br>- np<br>Pr[X 2 Observed] = Pr Z ><br>or Pr[X s Observed] = Pr| Z <<br>Vnp(1-p)<br>Vnp(1- p)<br>flowers of the Rewardless Orchid, Dactylorhiza sambucina are yellow, whereas the<br>remaining flowers are purple. For this problem, only use the normal approximation where it<br>is appropriate. Use the binomial distribution where the normal approximation is<br>inappropriate.<br>If we took a random sample of a single individual from this population, what is the<br>probability, reported as a percent, that is would be purple?<br>Determine the probability, reported as a decimal rounded to two decimal places, that if we<br>took a random sample of 6 flowers, at least 3 would be yellow.<br>If we took a random sample of 260 individuals, what is the probability, reported as a<br>decimal rounded to two decimal places, that 150 or more of the orchids are yellow?<br>](https://s3.us-east-1.amazonaws.com/storage.unifolks.com/qimg-008/008_pw2ozp0-xqp1dc0f.png)
Extracted text: 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 sucessful 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, and then use either the formula =(1-(norm.dist(Z,0,1,TRUE))) when calculating a right-tailed probability or the formula ={norm.dist(Z,0,1,TRUE)) for a left-tailed probability. In Europe, 53% of the Right-tailed tests find probabilities for X 2 observed while left-tailed tests find probabilities for X s observed 1 Observed - np Observed + - np Pr[X 2 Observed] = Pr Z > or Pr[X s Observed] = Pr| Z < vnp(1-p) vnp(1- p) flowers of the rewardless orchid, dactylorhiza sambucina are 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? determine the probability, reported as a decimal rounded to two decimal places, that if we took a random sample of 6 flowers, at least 3 would be yellow. 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? vnp(1-p)="" vnp(1-="" p)="" flowers="" of="" the="" rewardless="" orchid,="" dactylorhiza="" sambucina="" are="" 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?="" determine="" the="" probability,="" reported="" as="" a="" decimal="" rounded="" to="" two="" decimal="" places,="" that="" if="" we="" took="" a="" random="" sample="" of="" 6="" flowers,="" at="" least="" 3="" would="" be="" yellow.="" 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="">