In: Statistics and Probability
Using the worksheet, Quality, determine which wing of the company produces higher quality parts: Old Wing
and Job-enriched Wing. Alpha Value= 0.01
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?
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.01), 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.
Please give me a thumbs-up if this helps you out. Thank you! :)