Related questions with answers
(Use Excel) Color coding is often used in manufacturing operations to display production status or to identify/prioritize materials. For example, suppose "green" status indicates that an assembly line is operating normally, "yellow" indicates it is down waiting on personnel for set up or repair, "blue" indicates it is down waiting on materials to be delivered, and "red" indicates an emergency condition. Management has set realistic goals whereby the assembly line should be operating normally 80% of the time, waiting on personnel 9% of the time, waiting on materials of the time, and in an emergency condition 2% of the time. Based on recent status records, the status was green times, yellow times, blue times, and red times.
a. State the appropriate null and alternative hypotheses to test if the proportions of assembly line statuses differ from the goals set by management.
b. Calculate the value of the test statistic.
c. Use Excel's CHISQ.DIST.RT function to calculate the -value.
d. Are management's goals being met at ? Will your conclusion change at ?
Solution
VerifiedThe null hypothesis states that
so the alternative hypothesis will be the opposite.
The predicted values is equal to the proportion multiplied to . So in Mathematical terms, the null hypotheses is
and the Alternative hypotheses is
Create an account to view solutions
Create an account to view solutions
Recommended textbook solutions

Business Statistics: Communicating with Numbers
2nd Edition•ISBN: 9780078020551Alison Kelly, Sanjiv Jaggia
Basic Business Statistics: Concepts and Applications
12th Edition•ISBN: 9780132168380 (15 more)David M. Levine, Mark L. Berenson, Timothy C. Krehbiel

Modern Business Statistics with Microsoft Excel
5th Edition•ISBN: 9781285433301David R. Anderson, Dennis J. Sweeney, Thomas A. WilliamsMore related questions
1/4
1/7