TABLE 9- 1
Microsoft Excel Was Used on a Set

question 142

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-1, the probability of committing a Type II error is _ if the mean number of parasites per butterfly on Monarch butterflies in Pismo Beach State Park is 18 using a 0.05 level of significance and assuming that the population standard deviation is 25.92.

---

Definitions:

Interrupting

The act of breaking the continuity of someone's speech or activity without permission or invitation.

Anger

A strong feeling of annoyance, displeasure, or hostility, which can vary in intensity and be provoked by perceived wrongs or frustrations.

Hot Stove

An analogy often used in discipline, suggesting that, like touching a hot stove and experiencing immediate consequence, consequences of actions should be immediate, clear, and consistent.

Presentation

A structured delivery of information to an audience, often employing visual or auditory aids, designed to inform, persuade, or instruct.