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

question 42

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

---

Definitions:

Bronfenbrenner's Theory

A framework suggesting that an individual's development is affected by the interaction between their environment and various systemic layers, from immediate surroundings to broader societal influences.

Exosystem

A term from ecological systems theory referring to societal structures that do not directly contain the individual but still influence their experiences and development, such as parental workplaces.

Microsystem

The immediate environment a person operates in, including direct interactions with family, school, work, which influence one's development and behavior.

Multiple Choice Questions

A form of assessment where respondents are asked to select the correct answer(s) from several given options.