Instruction 9-2
Microsoft Excel Was Used on a Set of Data

question 22

Short Answer

Instruction 9-2
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-2,the power of the test is ________ if the mean number of parasites per butterfly on Blue Tiger butterflies in Kakadu National Park is 30 using a 0.1 level of significance and assuming that the population standard deviation is 25.92.

---

Definitions:

Final Offer Arbitration

A conflict resolution process where each party to a dispute makes a final offer, and an arbitrator chooses one of these offers as the resolution, without modification.

Compulsory Dispute Resolution

A legal requirement for conflicting parties to undergo a dispute resolution process, such as mediation or arbitration, before proceeding to litigation.

Arbitration

A method of resolving disputes outside the courts, where a neutral third party (the arbitrator) renders a decision after hearing arguments and evidence from both sides.

Unfair Labor Practice Strike

A strike undertaken by workers to protest actions by the employer that are considered illegal or unjust under labor laws.