Reference no: EM131099742
The data below are weights of sample cereal bars in grams for two shift workers at an industrial plant. They used two different independent machines for their shifts to cut the cereal bars into shapes to a given mass. Assume that a statistical test found that the mass of cereal bars follow a normal distribution. Therefore, we will perform a z- test on this data, even though the sample sizes are less than 30.
To do this, you must enter the data into Excel in two columns. In the previous week I asked you to install MegaStat as add-in to your Excel, and I provided the instructions for doing so. You can simply copy and paste the data into Excel, and make sure all the numbers are lined up correctly.
|
Shift 1
|
Shift 2
|
|
15
|
13.95
|
|
15
|
13.5
|
|
14.3
|
9
|
|
14.3
|
14.3
|
|
14.7
|
14.4
|
|
13.5
|
15
|
|
14.3
|
14.3
|
|
14.9
|
14.3
|
|
14.3
|
13.7
|
|
15
|
14.3
|
|
15
|
14.9
|
|
15
|
14.4
|
|
15
|
14.85
|
|
12.5
|
15
|
|
14.7
|
14.7
|
|
15
|
12.75
|
|
15
|
14.25
|
|
12.75
|
13.5
|
|
14.25
|
13.5
|
|
14.25
|
13.5
|
|
14.4
|
13.25
|
PROCEDURE:
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?
|
Write page critical self-reflection on your current skills
: Write two to three page critical self-reflection on your current skills and abilities as applied to the concepts of PERT estimating and Earned Value Management techniques. How comfortable are you with using tools? What professional training or edu..
|
|
Question regarding the male chromosome
: A geneticist conducts her survey and calculates hat p = 0.512. Which of the following is the most correct interpretation of this statistic? a) There is a 51.2% chance that a randomly selected gamete cell will have the male chromosome.
|
|
Ece 472-561 robotics and vision
: Devise a wire frame representation of a house. Specifically, the house is represented by 10 or more vertices in world coordinates. Simulate a camera and compute the pixel coordinates for each vertices. Draw the house using these pixel coordinates and..
|
|
If demand surges and pushes up the market price
: If demand surges and pushes up the market price to $20, industry-wide output will rise IN THE SHORT RUN due to..
|
|
Formulate the null and alternate hypothesis
: (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 ce..
|
|
Describe how you plan to search for the sudoku solution
: Describe how you plan to search for the Sudoku solution given a starting state. Clearly define your state space here: What does a vertex in your state traversal tree represent?
|
|
Calculating the benefits and costs from the merger
: Two Cournot duopolists produce in a market with demand P = 100 − Q. The marginal cost for firm 1 is constant and equals 10. The marginal cost for firm 2 is also constant and it equals 25. Given this information, would you recommend the merger? Explai..
|
|
Flagging my words against a french dictionary
: Right in the middle of a Word 2007 document I am typing, Word started flagging my words against a French dictionary. Why? How can I turn this off? I've changed my default language to English (U.S.), but that applies to future documents. Thanks.
|
|
Equal access to coolness for all coalition
: Assume that consumers are uniformly distributed along a one-mile stretch of beach. A number of ice cream vendors are pondering where to position their carts. If the price they are allowed to charge is fixed by the Equal Access to Coolness For All Coa..
|