The crab spider, Thomisus spectabilis, sitson flowers and preys upon visiting honeybees. Do honeybeesdistinguish between flowers that have crab spiders and flowers thatdo not? To test this, Heiling et al. (2003) gave 34 bees achoice between 2 flowers: one with, and one without a crab spider.In 23 of the 34 trials, the bees picked the flower that had thespider. In the other trials, the bees chose thespiderless flower.
With these data, carry out the appropriate hypothesis test (one-or two-tailed), using the normal approximation to the binomialdistribution to determine Z. For a one-tailed test, use theformula =(1-NORM.DIST(Z,0,1,TRUE) in Excelcalculate P. For a two-tailed test, use theformula =2(1-NORM.DIST(Z,0,1,TRUE).
State your answer for the value of P to threedecimal places, and include the leading zero.
- The Crab Spider Thomisus Spectabilis Sits On Flowers And Preys Upon Visiting Honeybees Do Honeybees Distinguish Betwe 1 (353.31 KiB) Viewed 9 times
Question 3 2.05 pts The crab spider, Thomisus spectabilis, sits on flowers and preys upon visiting honeybees. Do honeybees distinguish between flowers that have crab spiders and flowers that do not? To test this, Heiling et al. (2003) gave 34 bees a choice between 2 flowers: one with, and one without a crab spider. In 23 of the 34 trials, the bees picked the flower that had the spider. In the other trials, the bees chose the spiderless flower. With these data, carry out the appropriate hypothesis test (one- or two-tailed), using the normal approximation to the binomial distribution to determine Z. For a one-tailed test, use the formula =(1-NORM.DIST(Z,0,1,TRUE) in Excel calculate P. For a two-tailed test, use the formula =2(1-NORM.DIST(Z,0,1,TRUE). State your answer for the value of P to three decimal places, and include the leading zero. • Do all of the math in Excel • DO NOT round the value of Z. • Substitute the cell (e.g. B1) for Z in the formula for P.