Use a 10% significance level.
Every month a clothing store conducts an inventory and calculates the losses due to theft. The store would like to reduce these losses and is considering two methods. The first is to hire a security guard, and the second is to install cameras. To help decide which method to choose, they hired a security guard for six months. During the next 6 months period, the store installed cameras. The monthly losses were recorded and are listed here. The manager decided that since the cameras were cheaper than the guard, he would install the camera unless there was enough evidence to infer that the guard was better. What should the manger do?
Security guard 355 284 401 398 477 254
Cameras 486 303 270 386 411 435
This solution provides answers regarding hypothesis testing in Excel.