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:

pH

A numeric scale used to specify the acidity or basicity of an aqueous solution, where a value of 7 is neutral, values less than 7 are acidic, and values greater than 7 are basic.

Alanine

A non-essential amino acid used by the body to build proteins and play a key role in glucose metabolism.

Distilled Water

Water that has been boiled into vapor and recondensed into liquid, removing impurities and dissolved minerals.

Denaturation

The process by which proteins lose their native structure due to external stress or compounds, leading to a loss of biological activity.