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:

Children

Young human beings who are in the stages of development from infancy to puberty.

Time

A continuous, irreversible progression through past, present, and future, serving as a fundamental dimension in which events occur sequentially.

Restless Legs Syndrome

A disorder characterized by an uncontrollable urge to move the legs, usually because of an uncomfortable sensation, typically occurring in the evening or night.

Men

Refers to adult human males, often studied in various contexts including health, behavior, and societal roles.