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

question 112

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 null hypothesis would be rejected if a 5% probability
of committing a Type I error is allowed.

---

Definitions:

Cumulative Percent Frequency

A statistical measure that shows the percentage of observations that fall below or at a particular value when the data set is ordered.

Hours Worked

The total amount of time an individual spends performing tasks or activities related to employment within a given period.

Statistics Students

Individuals engaged in the study and analysis of data collection, interpretation, and presentation methods.

Frequency Distribution

A summary of how often each value in a set of data occurs, often displayed in a table or graphically as a histogram.