![haleyllevsen](/avatars/31064.jpg)
haleyllevsen
18.03.2021 •
Biology
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.
Solved
Show answers
More tips
- L Leisure and Entertainment When will Maslenitsa start?...
- F Food and Cooking Discovering the Mysterious Fruit of Feijoa...
- B Business and Finance How to Open an Online Store? A Detailed Guide for Beginners...
- W Work and Career How to Write a Resume That Catches the Employer s Attention?...
- C Computers and Internet Е-head: How it Simplifies Life for Users?...
- F Family and Home How to Choose the Best Diapers for Your Baby?...
- F Family and Home Parquet or laminate, which is better?...
- L Leisure and Entertainment How to Properly Wind Fishing Line onto a Reel?...
- L Leisure and Entertainment How to Make a Paper Boat in Simple Steps...
- T Travel and tourism Maldives Adventures: What is the Best Season to Visit the Luxurious Beaches?...
Answers on questions: Biology
- B Biology What is a atom? What does it do ?...
- E English Please answer the question below...
- B Biology What is used to measure when the cardiovascular system is receiving the most benefit from exercise without working too hard?...
- M Mathematics A multiple linear regression model of the following form is fitted to a data set Yi = β0 + β1xi1 + β2xi2 + εi , εi ∼ N(0, σ2 )i.i.d. The model is fitted using SAS and...
- M Mathematics A virus is spreading around Georgetown. At the moment, 530 people are infected. If the virus is spreading at a rate of 15% each day, how many people in all will have...
Ответ:
why u want us to join on your zoom