In: Statistics and Probability
EXCEL
Pecan Peanuts makes packets of nuts in its factory in the UK and currently uses two machines to fill the packets. A sample of 30 packets from the first machine has a mean weight of 180 g and a standard deviation of 40 g. A sample of 40 packets from the second machine has a mean weight of 170 g and a standard deviation of 10 g.
State the six-point procedure for hypothesis testing and test if the two machines are comparable in terms of putting the same amount in packets?
Insert six-point procedure, calculation and summarise result approx. 300 words - use cell for calculation( excel formulas to get the results).