Explore BrainMass

Explore BrainMass

    Questions for Hypothesis Testing in Excel

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com March 4, 2021, 8:49 pm ad1c9bdddf

    Solution Summary

    This solution provides answers regarding hypothesis testing in Excel.