$\text { TABLE 9-1 }$ Microsoft Excel Was Used on a Set of Data Involving

$\text { 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, if these data were used to perform a two-tailed test, the p-value would be 0.042.