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

question 6

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 18 using a 0.05 level of significance and assuming that the population standard deviation is 25.92.

---

Definitions:

Standard Costs

Predetermined costs for the manufacturing of products or performing services under normal conditions, used as benchmarks to measure actual performance.

Accountants

Professionals who manage and analyze financial records to ensure accuracy and compliance with laws and regulations.

Financial Expertise

The knowledge and skills related to managing money, investments, and financial analysis, often essential for making informed business decisions.

Normal Standards

Standards that represent levels of operation that can be attained with reasonable effort. Also called currently attainable standards.