The manufacturer of an airport baggage scanning machine claims it can handle an average of 580 bags per hour. At alpha (?) = .01, would a sample of 18 randomly chosen hours with a mean of 525 and a standard deviation of 45 support the manufacturer's claim? Do both by hand and with Excel.
Note- Use a 0.05 level of significance unless otherwise stated and do by hand and excel.
A Complete, Neat and Step-by-step Solution is provided in the attached file.