TABLE 9- 1
Microsoft Excel Was Used on a Set

question 102

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 with no more than a 1% probability of incorrectly rejecting the true null hypothesis.

---

Definitions:

Visuals

Images, diagrams, graphics, or any other visual elements used to convey information or support textual content.

Cross-hatching

An artistic technique used for shading and texturing by drawing closely spaced parallel lines that may intersect.

Borders

Decorative or functional lines around the edges of a page, text, or image used to define boundaries or add visual interest.

Captions

Textual descriptions provided for illustrations, photos, or videos to explain, interpret, or give context.