TABLE 9-1
Microsoft Excel Was Used on a Set

question 28

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 power of the test 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:

Price Level

A general measure of current prices for every type of good or service created in the economy.

Real Wage

The purchasing power of an individual's earnings, adjusted for inflation, reflecting the actual goods and services that wages can buy.

Monopsonist

A market condition where there is only one buyer for a product or service, giving that buyer significant control over the market.

MRP

Stands for Material Requirements Planning, a system used for production planning, scheduling, and inventory control.