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:

Presence of God

The belief or feeling that God exists and is actively involved in the world and in individual lives.

Civil Religion Theory

A concept that suggests the existence of a non-sectarian quasi-religious faith in the United States with sacred symbols drawn from national history, creating a cohesive social bond among Americans.

Desecularization Thesis

The theory that opposes the secularization thesis, proposing that instead of becoming less religious, the world is experiencing a resurgence of religious beliefs and practices.

Secularization Thesis

The theory that as societies progress, particularly through modernization and rationalization, religious authority diminishes in all aspects of social life and governance.