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

question 31

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 probability of committing a Type II error 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:

Letter Reports

Brief, informal reports typically addressed to individuals or small groups within an organization.

Transmittal Message

A communication, often accompanying a document or report, that provides the recipient with context or relevant details about the content being sent.

Routine Operational Reports

These are recurring reports prepared and disseminated at regular intervals to keep stakeholders informed about an organization's day-to-day operations.

Appended Parts

Components or sections added to a document or piece of writing.