![Excel add-in (Mega Stat) procedure: Step 1: In EXCEL, Select Add-Ins> Mega Stat> Hypothesis Tests. Step 2: Choose Compare Two](//img.homeworklib.com/questions/6a962920-32c5-11eb-a5ff-116106bacaf6.png?x-oss-process=image/resize,w_560)
![Hypothesis Test: Independent Groups (t-test, unequal variance) Men Women 12.5 11.3 mean 181.7std. dev. 18 12n 24 df 1.2000 di](//img.homeworklib.com/questions/6b262640-32c5-11eb-958e-f1e7b9946e75.png?x-oss-process=image/resize,w_560)
![Conclusion: Use a significance level, α 0.05. Here, p-value is 0.9617, which is greater than the value of α-005- That is, p-v](//img.homeworklib.com/questions/6b9cdbf0-32c5-11eb-9f8a-5369f9d9ca15.png?x-oss-process=image/resize,w_560)
Excel add-in (Mega Stat) procedure: Step 1: In EXCEL, Select Add-Ins> Mega Stat> Hypothesis Tests. Step 2: Choose Compare Two Independent Groups. Step 3: Choose Summary Input. Step 4: In Group 1, enter B1:B4 (Select ranges with label mean, SD, n). Step 5: In Group 2, enter D1:D4 (Select ranges with label mean, SD, n). Step 6: Enter 0 Under Hypothesized difference. Step 7: Check t-test (unequal variance), enter Confidence level as 95.0 Step 8: Choose less than in alternative. Step 9: Click OK. Excel add-in (Mega Stat) output:
Hypothesis Test: Independent Groups (t-test, unequal variance) Men Women 12.5 11.3 mean 181.7std. dev. 18 12n 24 df 1.2000 difference (Men Women) 0.6487 standard error of difference 0 hypothesized difference 1.85 t 9617 p-value (one-tailed, lower) Thus the p-value is 0.9617
Conclusion: Use a significance level, α 0.05. Here, p-value is 0.9617, which is greater than the value of α-005- That is, p-value0.9617) a(0.05) Therefore, by the rejection rule, do not reiect the null hypothesis Ho Interpretation There is no sufficient evidence at level of significance a 0.05 That is, women and men are performing complex and detailed assembly tasks in manufacturing