TABLE 9-1
Microsoft Excel Was Used on a Set of Data

question 174

Short Answer

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-4, what is the power of the test if the average effective time of the anesthetic is 7.0 using a 0.05 level of significance?

---

Definitions:

Fungal Body

The physical structure of a fungus, including mycelium and fruiting bodies, which supports growth, reproduction, and nutrient absorption.

Function

A specific purpose or role of a component or system.

Decomposer

Organisms, typically bacteria and fungi, that break down dead or decaying organisms, thereby playing a key role in the nutrient cycle.

Saccharomyces

A genus of fungi that includes many yeast species, widely used in baking, brewing, and wine-making.