In: Statistics and Probability
2. Using the worksheet, Quality, determine which wing of the company produces higher quality parts: Old Wing
and Job-enriched Wing.
a. Which statistical analysis should be used to answer this question?
b. What are the null and alternative hypotheses?
c. Conduct the appropriate statistical analysis on Excel or StatCrunch. Provide a copy of your output.
d. Using your output, what is the p-value?
e. Using your output, what is the test statistic?
f. What is your decision?
g. Based on your decision, what is your conclusion?
3. Based on the analyses conducted in Questions #1 and #2, what conclusion do you reach about the success of the
Job Enrichment program? Support your answer with your analyses and decisions.
Quality Sheet below:
Old Wing | Job-Enriched Wing |
Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Defective |
Not Defective | Not Defective |
Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Defective |
Not Defective | Not Defective |
Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Not Defective | Not Defective |
Defective | Not Defective |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Not Defective | |
Defective |
2. Using the worksheet, Quality, determine which wing of the company produces higher quality parts: Old Wing
and Job-enriched Wing.
a. Which statistical analysis should be used to answer this question?
Two-sample proportion test
b. What are the null and alternative hypotheses?
The hypothesis being tested is:
H0: p1 = p2
Ha: p1 ≠ p2
c. Conduct the appropriate statistical analysis on Excel or StatCrunch. Provide a copy of your output.
The Excel output is:
d. Using your output, what is the p-value?
The p-value is 0.3985.
e. Using your output, what is the test statistic?
The test statistic is -0.84.
f. What is your decision?
Since the p-value (0.3985) is greater than the significance level (0.05), we cannot reject the null hypothesis.
g. Based on your decision, what is your conclusion?
Therefore, we cannot conclude that any particular wing of the company produces higher quality parts.
3. Based on the analyses conducted in Questions #1 and #2, what conclusion do you reach about the success of the
Job Enrichment program? Support your answer with your analyses and decisions.
We can conclude that the number of parts produced is different between the two programs: Old program and Job-enriched program.
We cannot conclude that any particular wing of the company produces higher quality parts.
Please give me a thumbs-up if this helps you out. Thank you! :)