TABLE 9-1
Microsoft Excel Was Used on a Set $0.10$

question 158

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 wantsto know if the mean number of parasites per butterfly is over 20 . She will make her decision usinga test witha level of significance of $0.10$ . The following informationwas extracted from the Microsoft Excel outputfor the sample of 46 Monarchbutterflies:

$\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 24 using a 0.1 level of significance and assuming that the population standard deviation is 25.92.

---

Definitions:

Insurance Coverage

The extent of protection provided under an insurance policy, detailing what costs the insurer will cover in the event of certain losses or health care needs.

Clustering

The act of grouping a set of objects based on their similarities, often used in statistical analysis or data mining.

Streaming

The practice of transmitting or receiving data (especially video and audio material) over the internet in a continuous flow, allowing immediate access.

Modified Wave

A scheduling system designed to minimize waiting time by allocating appointments at specific intervals, allowing for walk-ins or emergencies.