Assume you are the manager of a mustard seed factory in Colombia. Your company has received complaints that there isn't enough mustard seed in your economy size packages, which should have 1,7 ounces. You ask your foreman and chief operating officer Juan Valdez to test the new mustard seed packaging machine you are installing. He runs a sample of 36 packages, with the results of package sizes in ounces. See Data Set below: 1.5 1.75 1.8 1.7 1.8 1.3 1.7 1.66 2.2 1.7 1.91 2 1.8 1.81 1.7 1.6 1.7 1.91 1.91 1.65 1.65 1.65 1.59 1.65 1.7 1.77 1.88 1.65 1.76 1.8 1.75 1.75 1.6 1.65 1.65 1.8 A. Calculate a 95% confidence interval on the average weight of package mustard seed. Explain very carefully to the packaging workers what the 95% confidence interval numbers mean. Is there anything you would want to note for management? B. Use the same dataset you used for the previous problem. Over a period of time, Juan determines that the true mean for the packages is in fact 1.72 ounces with a standard deviation the same as the sample above. Assume that Juan has a strong consumer orientation. Juan is also a savvy businessman. Indeed a local TV station has been checking up on Juan by periodically sampling 36 packages and figuring up the average weight. Juan tells you that he wants to be at least 95% sure that the average package has at least 1.7 ounces. Further he wants to be sure that 95% of the time, the TV crew that is watching him will find a sample mean of at least 1.70 ounces. At the same time, he doesn't want to set the equipment to fill packages with any more product than he absolutely has to. What advice would you give the mustard seed packaging factory management as to how to calibrate the equipment? In particular, should they increase or decrease the amount they are putting in the packages and by how much? Are there any other steps they migth be able to take to improve the situation? Thanks for answer. Additional question:

1. Now, let's assume that the package claims that it contains 1.7 oz. of mustard seed. Some of the customers claim that there isn't enough mustard seed in the 1.7 oz. economy size; corporate management is worried that there may be too much. Given the sample of 36, assuming that it is adequate, test the hypothesis that the average amount of mustard seed in the package meets the 1.7 oz. standard with, say, 95% confidence. Be sure to state the null and alternative hypothesis and which you support. Include your Excel output. For extra assistance, reference section 9.3 and page 346 > USING THE COMPUTER > Excel > "To perform a T test of a single mean", etc. Is there anything you would want to note for management?