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 24 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.
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 24 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.
Human Anatomy & Physiology (11th Edition)
11th Edition
ISBN:9780134580999
Author:Elaine N. Marieb, Katja N. Hoehn
Publisher:Elaine N. Marieb, Katja N. Hoehn
Chapter1: The Human Body: An Orientation
Section: Chapter Questions
Problem 1RQ: The correct sequence of levels forming the structural hierarchy is A. (a) organ, organ system,...
Related questions
Question
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 24 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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, biology and related others by exploring similar questions and additional content below.Recommended textbooks for you
Human Anatomy & Physiology (11th Edition)
Biology
ISBN:
9780134580999
Author:
Elaine N. Marieb, Katja N. Hoehn
Publisher:
PEARSON
Biology 2e
Biology
ISBN:
9781947172517
Author:
Matthew Douglas, Jung Choi, Mary Ann Clark
Publisher:
OpenStax
Anatomy & Physiology
Biology
ISBN:
9781259398629
Author:
McKinley, Michael P., O'loughlin, Valerie Dean, Bidle, Theresa Stouter
Publisher:
Mcgraw Hill Education,
Human Anatomy & Physiology (11th Edition)
Biology
ISBN:
9780134580999
Author:
Elaine N. Marieb, Katja N. Hoehn
Publisher:
PEARSON
Biology 2e
Biology
ISBN:
9781947172517
Author:
Matthew Douglas, Jung Choi, Mary Ann Clark
Publisher:
OpenStax
Anatomy & Physiology
Biology
ISBN:
9781259398629
Author:
McKinley, Michael P., O'loughlin, Valerie Dean, Bidle, Theresa Stouter
Publisher:
Mcgraw Hill Education,
Molecular Biology of the Cell (Sixth Edition)
Biology
ISBN:
9780815344322
Author:
Bruce Alberts, Alexander D. Johnson, Julian Lewis, David Morgan, Martin Raff, Keith Roberts, Peter Walter
Publisher:
W. W. Norton & Company
Laboratory Manual For Human Anatomy & Physiology
Biology
ISBN:
9781260159363
Author:
Martin, Terry R., Prentice-craver, Cynthia
Publisher:
McGraw-Hill Publishing Co.
Inquiry Into Life (16th Edition)
Biology
ISBN:
9781260231700
Author:
Sylvia S. Mader, Michael Windelspecht
Publisher:
McGraw Hill Education