SCENARIO 9-1 Microsoft Excel Was Used on a Set of Data Involving

question 40

True/False

SCENARIO 9-1
Microsoft Excel was used on a set of data involving the number of defective items found in a random
sample of 46 cases of light bulbs produced during a morning shift at a plant.A manager wants to
know if the mean number of defective bulbs per case is greater than 20 during the morning shift.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 cases:
-True or False: Referring to Scenario 9-1, the manager can conclude that there is sufficient
evidence to show that the mean number of defective bulbs per case is greater than 20 during the
morning shift using a level of significance of 0.10.

---

Definitions:

Future Value

The value of an asset or cash at a specified date in the future that is equivalent in value to a specified sum today, taking into account interest or return on investment.

Perpetuity

A type of annuity that continues indefinitely, providing consistent periodic payments.

Break-Even Rate

The interest rate at which the present value of a project's or investment's costs equals the present value of its benefits, there is no net loss or gain.

Annuity A

Represents a financial product that promises to pay the holder a fixed stream of payments over a specified period of time.