TABLE 9-1
Microsoft Excel Was Used on a Set of Data

question 77

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 power of the test 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:

Centre of Gravity

The point in a body or system around which its mass or weight is evenly distributed or balanced.

Base of Support

The area beneath an object or person that includes every point of contact that the object or person makes with the supporting surface, essential for stability.

Drawsheets

Small bed linens placed crosswise over the middle of the bottom sheet to assist in repositioning or lifting a patient in bed.

Position

The way in which someone or something is placed or arranged in relation to its surroundings.