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

question 117

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

---

Definitions:

Accumulated Depreciation

The total depreciation for a fixed asset that has been charged to expense since that asset was acquired and made available for use.

Cash Price

The price of an item for immediate payment, as opposed to a higher price when paying on credit.

Productivity

A measure of efficiency, typically defined as the output of goods or services produced per unit of input, such as labor or capital.

Salvage Value

The forecasted remaining worth of an asset after its period of functionality has ended.