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

question 125

True/False

TABLE 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:

-Referring to Table 9-1, the evidence proves beyond a doubt that the mean number of defective bulbs per case is greater than 20 during the morning shift.

---

Definitions:

Standard Deviation

A parameter reflecting the extent of diversity or spread in a group of numbers.

Normally Distributed

A type of distribution in which data points are symmetrically distributed around the mean, forming a bell-shaped curve.

Standard Deviation

A measure that quantifies the amount of variation or dispersion of a set of values from the mean.

Finite Population Correction Factor

A factor applied in sample size formulae to adjust for the effect of sampling without replacement from a finite population.