Explore BrainMass

Explore BrainMass

    Call Center Data & Home Market Data

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

    I need quick help. I bought help for each of these problems on this site but have been unable to get help figuring out why there are no calculations in any of the cells, only numbers. The person who posted it was no help and I needed this today (Sunday 7/21). Additionally, there is no explanation for any of the outcomes, as per the instructions in the questions.

    I need someone who can look at these and put the right calculations or formulas into the cells AND explain the outcomes. I just don't understand.

    I really need this tomorrow...Monday 7/22 by 8:00p.m. EST.

    © BrainMass Inc. brainmass.com June 4, 2020, 4:10 am ad1c9bdddf


    Solution Preview

    Please see the attachments. The solutions provide the step by step method for the calculation in word as well as excel files so that you can understand the concept easily. If you have any doubt, please do not hesitate to contact me.

    5-1: 1. Call centers typically have high turnover. The director of human resources for a large bank has compiled data on about 70 former employees at one of the bank's call centers in the Excel file Call Center Data. In writing an article about call center working conditions, a reporter has claimed that the average tenure is no more than two years. Formulate and test a hypothesis using these data to determine if this claim can be disputed. Solution Tip: You need to write mathematical test of hypothesis statements and apply the test of hypothesis steps.


    The null hypothesis tested is
    H0: Mean tenure in call centres ≤ 2 years (µ ≤ 2)
    The alternative hypothesis is
    H1: Mean tenure in call centres > 2 years (µ > 2)
    Significance level = 0.05
    Test Statistic used is . Given that = 1.89, n = 70, s = 1.098178502
    Therefore, = -0.805992914
    Decision rule: ...

    Solution Summary

    The call center data and home market data is given.