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

question 79

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 probability of committing a Type II error is _____ if the mean number of parasites per butterfly on Monarch butterflies in Pismo Beach State Park is 30 using a 0.05 level of significance and assuming that the population standard deviation is 25.92.

---

Definitions:

Automatic Stabilizers

Economic policies and programs, such as unemployment benefits and progressive taxation, that automatically help stabilize an economy by increasing spending in a downturn and reducing spending in an upswing without additional government action.

Private Spending

Private Spending is the total expenditures by individuals and businesses in an economy, excluding government spending and investment.

Transfer Payments

Payments made by the government to individuals or organizations without requiring any goods or services in return, such as welfare checks or social security.

Business Cycle

The fluctuations in economic activity that an economy experiences over a period, typically characterized by expansion (growth) and contraction (recession) phases.