TABLE 9- 1
Microsoft Excel Was Used on a Set

question 45

True/False

TABLE 9- 1
Microsoft Excel was used on a set of data involving the number of parasites found on 46 Monarch butterflies captured in Pismo Beach State Park. A biologist wants to know if the mean number of parasites per butterfly is over 20. She will make her decision using a test with a level of significance of 0.10. The following information was extracted from the Microsoft Excel output for the sample of 46 Monarch butterflies:

$\begin{array}{llcc} \hline n=46 ; \text { Arithmetic Mean }=28.00 ; \text { Standard Deviation }=25.92 ; \text { Standard Error }=3.82 ; \\\text { Null Hypothesis:} H_{0}: \mu \leq 20.000 ; \alpha=0.10 ; d f=45 ; T \text { Test Statistic} = 2.09;\\\text { One-Tailed Test Upper Critical Value} =1.3006 ;\text { p-value} =0.021 ; \text { Decision = Reject.}\\\hline\end{array}$


-Referring to Table 9-1, the biologist can conclude that there is sufficient evidence to show that the average number of parasites per Monarch butterfly in Pismo Beach State Park is over 20 using a level of significance of 0.10.

---

Definitions:

Hemocyanin

A copper-containing protein found in the blood of some invertebrates, like mollusks and arthropods, serving as an oxygen carrier.

Diffusion

The movement of molecules or particles from an area of high concentration to an area of low concentration.

Shape of Organism

The form or structure of a living entity, influenced by genetic and environmental factors.

Size of Organism

Refers to the physical dimensions of an individual organism, which can vary widely across different species and within a species.