TABLE 9- 1
Microsoft Excel Was Used on a Set

question 33

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

---

Definitions:

Interest Rates

The percentage charged or paid for the use of money, typically expressed as an annual rate provided by lenders to borrowers.

Bond Prices

The market cost of bonds, which can fluctuate based on interest rate movements, credit quality, and other factors.

Retractable Bonds

Bonds that provide the holder the option to redeem them at a predetermined price before maturity, potentially at par value or a slight premium.

Interest Rates

The fee, shown as a percentage of the total amount loaned, that a lender imposes on a borrower for the right to use their funds.