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

question 92

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

Understand the concept of a check register and how to record transactions in it.

Develop proficiency in calculating the adjusted cash balance by adding deposits and subtracting checks written.

Acquire skills to reconcile cash balances with bank statements or completion of check stubs.

Enhance mathematical skills specifically in addition and subtraction of monetary values in the context of business transactions.

---

Definitions:

Changing Circumstances

Situations that evolve over time, necessitating adjustments in strategy, plans, or behavior.

Forecasting

The process of attempting to predict the future.

Human Judgment

The cognitive process of forming opinions or making decisions based on available information and personal beliefs.

Scenario Planning

A strategic planning method that organizations use to envision and prepare for various future conditions or events.