subject
Biology, 18.03.2021 05:50 mrym7d

Please help how do I do this in excel?!?! 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 33 bees a choice between 2 flowers: one with, and one without a crab spider. In 21 of the 33 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.

ansver
Answers: 1

Other questions on the subject: Biology

image
Biology, 22.06.2019 04:30, tk1264
What is the similarities and differences between bacteria and eukaryote?
Answers: 3
image
Biology, 22.06.2019 12:20, Yumimiku6539
Which organ controls breathing? lungs alveoli heart diaphragm
Answers: 2
image
Biology, 22.06.2019 12:30, minervica
The table presents the average day and night temperatures in five cities. it also reveals whether a city receives substantial rainfall (wet climate) or little rainfall (dry climate). which city’s rocks are likeliest to experience frost wedging, and why? a) city a because the consistently subzero temperature would prevent water from melting b) city b because it is a wet region and the temperature fluctuates around the freezing point c) city c because it receives plenty of rain fall and the weather is moderately cool d) city d because the hot and dry weather would cause rocks to absorb water
Answers: 3
image
Biology, 22.06.2019 16:00, kcdavis318
Why are some places regularly warmer or cooler than others in a given month
Answers: 3
You know the right answer?
Please help how do I do this in excel?!?! The crab spider, Thomisus spectabilis, sits on flowers an...

Questions in other subjects:

Konu
Mathematics, 18.12.2019 10:31
Konu
Geography, 18.12.2019 10:31