Instruction 9-7
Microsoft Excel Was Used on a Set $n = 46$

question 122

Short Answer

Instruction 9-7
Microsoft Excel was used on a set of data involving the number of parasites found in a random sample of 46 Blue Tiger butterflies captured in Kakadu National Park. A biologist wants to know if the mean number of parasites per butterfly is greater than 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 butterflies:
$n = 46$ ; Arithmetic Mean $= 28.00$ ; Standard Deviation $= 25.92$ ; Standard Error $= 3.82$ ;
Null Hypothesis: $H _ { 0 } : \mu \leq 20.000 ; a = 0.10 ; \mathrm { df } = 45 ; T$ Test Statistic $= 2.09$ ;
One-Tailed Test Upper CriticalValue $= 1.3006 ; p$ value $= 0.021$ ; Decision $=$ Reject.
-Referring to Instruction 9-7,the lowest level of significance at which the null hypothesis can be rejected is______.

---

Definitions:

Balance Sheet

A financial statement that summarizes a company’s assets, liabilities, and shareholders’ equity at a specific point in time, offering a snapshot of its financial position.

Producers

Producers are individuals, companies, or entities that create, manufacture, or furnish goods or services for consumption in the economic supply chain.

Commodities

Basic goods used in commerce that are interchangeable with other goods of the same type, often used as inputs in the production of other goods or services.

Established Price

The known or fixed cost of a good or service in the marketplace, often determined by supply and demand factors or regulatory authorities.