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:

Electroconvulsive Therapy

A medical treatment involving electrically induced seizures intended for severe mental disorders, notably major depression.

Memory Loss

The inability to remember information or events that should normally be retainable; it can be partial or complete, temporary or permanent.

Deep-brain Stimulation

A neurosurgical procedure that uses implanted electrodes to send electrical impulses to specific parts of the brain.

Electroconvulsive Therapy

A medical treatment for severe mental illness in which electric currents are passed through the brain, intentionally triggering a brief seizure to provide therapeutic effects.