### Hypothesis Testing with Normal Approximation#### Context:The crab spider, *Thomisus spectabilis*, sits on flowers and preys upon visiting honeybees. A study by Heiling et al. (2003) investigated whether honeybees can distinguish between flowers that have crab spiders and those that do not. In this experiment, 33 bees were given a choice between two flowers: one with a crab spider and one without. Bees chose the flower with the spider in 23 out of the 33 trials, opting for the flower without the spider in the other trials.#### Objective:Use the given data to carry out the appropriate hypothesis test (either one-tailed or two-tailed) using the normal approximation to the binomial distribution.#### Procedure for Hypothesis Testing:1. **Determine Z using the following formulas:** - For a one-tailed test: `=1-NORM.DIST(Z,0,1,TRUE)` in Excel to calculate \( P \) - For a two-tailed test: `=2*(1-NORM.DIST(Z,0,1,TRUE))` in Excel to calculate \( P \)2. **State your answer for the value of \( P \) to three decimal places, and include the leading zero.**#### Instructions:- Perform all calculations in Excel.- Do NOT round the value of \( Z \).- Substitute the cell (e.g., B1) for \( Z \) in the formula for \( P \).**Ensure your final answer for \( P \) is precise up to three decimal places.**---Text Input Box (for student submission):```[ ]```---This section is relevant for students learning about hypothesis testing and statistical analysis, aiding them with a practical example and clear instructions for using Excel for statistical calculations.

Given Information: Number of trials n=33 In x=23 trials of the total trials, the bees picked the…

Answered: The crab spider. Thomisus spectabilis,…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

An airline wants to select a computer software package for the reservation system. Four software packages (1,2,3,4) are commercially available. The airline will choose the package that bumps as few passengers, on average, as possible during a month. An experiment is set up in which each package is used to make reservations for 5 randomly selected weeks. A total of 20 weeks was included in the experiment. The number of passengers bumped each week is obtained, which gives rise to the following output analysis as in Output 1. Based on Output 1, the total degrees of freedom are Output 1 ANOVA Source of Variation Between Groups df MS p-value F crit 212.4 8.304985 0.001474 3.238867 3. Within Groups 136.4 8.525 Total 348.8 16 19
A researcher studies the effects of guilt on memory. First, subjects perform a very boring task for one hour. Then each subject is instructed to tell the next subject either (a) that the experiment took one hour and they found it very boring, or (b) that the experiment took one hour and was very interesting. After that, each subject is asked to study a list of words and are tested on memory for the list. 30 subjects are randomly assigned to one of the two conditions. In order to see whether the experimental manipulation has any effect on memory, which would be the proper statistical test? A)a related sample t-test-test   B)an independent sample t-test   C)a z test   D)a one sample t
An airline wants to select a computer software package for its reservation system. Four software packages (1, 2, 3, and 4) are commercially available. The airline will choose the package that bumps as few passengers, on the average, as possible during a month. An experiment is set up in which each package is used to make reservations for five randomly selected weeks. (A total of 20 weeks was included in the experiment.) The number of passengers bumped each week is given below. Package 1: 12, 14, 9, 11, and 16 Package 2: 2, 4, 7, 3, and 1 Package 3: 10, 9, 6, 10, and 12 Package 4: 7, 6, 6, 15, and 12 The airline uses ticket value as a control variable. Which of the following tests is appropriate for testing the software's use? A. t test for the mean difference between matched pairs B. ANOVA F test C. ANCOVA F test D. t test for the differences in means
Researchers constructed two test sheets, each sheet including 20 photos of the faces of dog–owner pairs taken at a dog lovers' field festival. The 20 sets of dog–owner pairs on the two sheets were equivalent with respect to breed, diversity of appearance, and gender of owners. On the first sheet, the dogs were matched with their owners, while on the second sheet, the dogs and owners were deliberately mismatched. Three experiments were conducted, and in all experiments, subjects were asked to "choose the set of dog–owner pairs that resemble each other, Sheet 1 or Sheet 2," and were simply told the aim of the research was a "survey on dog–owner relationships." In the first experiment, the original sheets were shown to subjects; in the second experiment, just the "mouth region" of the owners was blacked out in all the pictures on both sheets; in the third experiment, just the "eye region" of the owners was blacked out. Subjects were assigned at random to the three experimental groups, and…
g) The Lady Tasting Tea Experiment. An English lady, Muriel Bristol, claimed that she can tell whether tea or milk was added first to a cup. So as a researcher, you want to test whether she can really tell whether tea or milk was added first. But how would you do it? A possible research design: Give her eight cups, four where tea is added first and the other four where milk is added first, in random order. Then ask her to pick out the four cups where the milk is added first. After you conducted the experiment and collected the data, how do you decide whether she can truly tell the difference or she was just guessing. Our intuition tells us that the more cups she gets correctly, the more likely that she is NOT guessing. "If the Lady is just guessing, the probability of getting it all correctly is 1.4%." Now using your knowledge on combinatorics and probability, explain how this number was calculated? h) Suppose you flip four fair coins. What is the probability that you will get all…
5. An office manager is looking to purchase a new printer for his office. He has narrowed his choices down to four printers but cannot decide which of the four he prefers. He has decided to choose two of the four printers at random, and then to let the other members of the office decide which of the two they prefer. The speeds, in pages per minute, of the four printers are 25, 30, 27, and 32. Considering the speeds of the two printers chosen to be the sample, what are the mean and the standard deviation of the sample mean?
An Internet service provider is considering four different servers for purchase. Potentially, the company would be purchasing hundreds of these servers, so it wants to make sure it is making the best decision. Initially, five of each type of server are borrowed, and each is randomly assigned to one of the 20 technicians (all technicians have similar skills). Each server is then put through a series of tasks and rated using a standardized test. The higher the score on the test, the better the performance of the server. The data are shown below. Use the KRUSKAL-WALLIS TEST to determine if the are differences among the servers. Use α = 0.1. 48.5 46.5 52.4 54.1 58.9 56.4 68.2 68.5 64.2 60.1 52.1 64.3 56.3 68.3 48.3 72.2 52.2 70.6 58.4 56.5
A poll was taken of 100 students at a commuter campus to find out how they got to campus. The results were as follows: 31 said they drove alone. 32 rode in a carpool. 28 rode public transportation. 4 used both carpools and public transportation. 5 used both a carpool and sometimes their own cars. 3 used buses as well as their own cars. 1 used all three methods. How many used none of the above-mentioned means of transportation?students
250 adults are practicing every day before taking part in a high-stakes children's game. The game requires them carefully to remove a shape- either a star or an umbrella-from a sugar wafer. 30% of those who choose stars on a given day will switch to umbrellas the next day, and 20% of those who choose umbrellas on a given day will switch to stars the next day. (a) If 150 contestants practice with stars today, how many will practice with umbrellas tomorrow? (b) If the actual game is held a long time from now, what proportion of contestants do we expect will be practicing with stars each day close to then?
A person, Joe, claims to be able to "smell" an illness based on the odor of a person's clothing. Joe is given 12 shirts, each worn by a different person, some of whom had the illness and some of whom did not. The shirts were given to Joe in random order and he had to decide whether each shirt had been worn by an ill patient or by a healthy patient. joe identified 11 of the 12 shirts correctly. If we assume that Joe was just guessing, he would have probability 1/2 of correctly identifying each shirt. Find the probability that Joe would identify AT LEAST 11 shirts correctly by random guessing
Bowl A contains 2 red chips; bowl B contains two white chips; and bowl C contains 1 red chip and 1 white chip. A bowl is selected at random, and one chip is taken at random from that bowl.
Researchers believed that floral scent can sometimes improve a person's learning ability. They set up an experiment in which each of 22 subjects completed sets of pencil-and-paper mazes. Each subject wore a floral-scented mask and an unscented mask, where the order in which the masks were presented was random. The researchers measured the time to complete the sets of mazes. This experimental design is: a matched pairs design. a confounding design. a double-blind design. a completely randomized design.

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS