From the Add-ins tab in Excel select MegaStat, then select Hypothesis tests, then select “Compare two independent groups.” For Group 1, place the cursor into the space and go scroll from top to bottom the results for Shift 1 in the Excel column, including the heading. For Group 2, place the cursor in the space and go scroll from top to bottom the results for Shift 2 in the Excel column, including the heading. For hypothesized difference, select zero.” For Alternative, select “greater than.” Make sure that z-test is checked. Click OK.
Copy and paste your results into your response, and answer the questions below.
Questions:(1) In this exercise how would you formulate the null and alternate hypothesis? Is this a one-tailed test, or a two-tailed test?
(2) Based on the output, can we conclude at the 5% level of significance that the machine used in shift 1 overcuts the cereal bars? How?
z-Test: Two Sample for MeansShift 1Shift 2Mean14.43571 13.87381Known Vari 0.525536 1.632405Observatio2121Hypothesiz0z1.752882P(Z<=z) one0.039811z Critical o 1.644854P(Z<=z)…