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

question 43

True/False

$\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, the value of þ is 0.90.

---

Definitions:

Ownership Interest

An individual's or entity's legal share or involvement in an asset, which grants rights and potential financial benefits.

Maturity Value

The amount payable to an investor at the end of a debt instrument's holding period or maturity date, including both the principal and any remaining interest payments.

Stated Rate

The interest rate stated on the face of a bond or other fixed-income security, which is used to calculate the interest payments to the bondholders.