TABLE 9- 1
Microsoft Excel Was Used on a Set

question 95

Multiple Choice

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\bar{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;\text { T 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, what critical value should the biologist use to determine the rejection region?

• A) 0.6800
• B) 1.3006
• C) 1.3011
• D) 1.6794

---

Definitions:

Overhead Applied

The allocated portion of overhead costs assigned to individual units or activities, based on a predetermined overhead rate.

Machining Department

A segment within a manufacturing facility where machining processes such as cutting, drilling, or shaping materials are carried out.

Overhead Applied

The amount of overhead costs allocated to the production of goods or services, often based on a predetermined overhead rate.

Assembly Department

A section within a manufacturing facility where assembly of the final product or parts of it takes place.