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

question 174

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-4, what is the power of the test if the average effective time of the anesthetic is 7.0 using a 0.05 level of significance?

---

Definitions:

Reporting Relationships

The structural connections within an organization that outline who reports to whom.

High-Performance Work System

High-performance work systems are organizational approaches that integrate human resource practices, work processes, and technology to stimulate employee productivity and effectiveness.

Task Significance

The degree to which a job has an impact on the lives or work of other people within or outside the organization.

High Product Quality

A measure of the excellence or a state of being free from defects, deficiencies, and significant variations, brought by stringent and consistent adherence to measurable and verifiable standards to meet the customer's requirements.