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.

Answers: 1

Show answers

Other questions on the subject: Biology

Biology, 21.06.2019 22:30, lillitzy8865

How do tides affect the organisms living in intertidal zones? a. no organisms live in intertidal zones due to the tumultuous environment. b. the mechanical forces of the waves keeps the organisms clean. c. only plants live in intertidal zones because the animals float away with the waves and never return. d. the mechanical forces of the waves can dislodge the organisms from their habitat.

Answers: 2

continue

Biology, 22.06.2019 04:30, Officaljazz18

Asap brainliest will be which sentence about protists is accurate? all protists are unicellular and microscopic in nature. they have organelles, so protists are eukaryotic in nature. all protists make their own energy through photosynthesis.

Answers: 1

continue

Biology, 22.06.2019 06:00, nauticajanke03

The empty trna moves off and picks up another matching amino acid from the cytoplasm in the cell. the anticodon of the trna, with its attached amino acid, pairs to the codon of the mrna, which is attached to a ribosome. this sequence is repeated until the ribosome reaches a stop codon on the mrna, which signals the end of protein synthesis. the ribosome forms a peptide bond between the amino acids, and an amino acid chain begins to form. when a second trna with its specific amino acid pairs to the next codon in sequence, the attached amino acid breaks from the first trna and is bonded to the amino acid of the second trna.

Answers: 1

continue

Biology, 22.06.2019 06:40, lusan4u

Most of the carbon on earth is stored in the form of

Answers: 2

continue

You know the right answer?

Please help how do I do this in excel?!?! The crab spider, Thomisus spectabilis, sits on flowers an...