Determine the average time in queue

Assignment Help Finance Basics
Reference no: EM132637946

Hypothesis testing

Context: Your organization is evaluating the quality of its call center operations. One of the most important metrics in a call center is Time in Queue (TiQ), which is the time a customer has to wait before he/she is serviced by a Customer Service Representative (CSR). If a customer has to wait for too long, he/she is more likely to get discouraged and hang up. Furthermore, customers who have to wait too long in the queue typically report a negative overall experience with the call. You've conducted an exhaustive literature review and found that the average TiQ in your industry is 2.5 minutes (150 seconds).

Another important metric is Service Time (ST), also known as Handle Time, which is the time a CSR spends servicing the customer. CSR's with more experience and deeper knowledge tend to resolve customer calls faster. Companies can improve average ST by providing more training to their CSR's or even by channeling calls according to area of expertise. Last month your company had an average ST of approximately 3.5 minutes (210 seconds). In an effort to improve this metric, the company has implemented a new protocol that channels calls to CSR's based on area of expertise. The new protocol (PE) is being tested side-by-side with the traditional (PT) protocol.

Instructions:

Access the CallCenterWaitingTime.xlsx file. Each row in the database corresponds to a different call. The column variables are as follows:

  1. ProtocolType: indicates protocol type, either PT or PE
  2. QueueTime: Time in Queue, in seconds
  3. ServiceTime: Service Time, in seconds

Question 1: Perform a test of hypothesis to determine whether the average TiQ is lower than the industry standard of 2.5 minutes (150 seconds). Use a significance level of α=0.05.

Question 2: Evaluate if the company should allocate more resources to improve its average TiQ.

Question 3: Perform a test of hypothesis to determine whether the average ST with service protocol PE is lower than with the PT protocol. Use a significance level of α=0.05.

Question 4: Assess if the new protocol served its purpose. (Hint: this should be a test of means for 2 independent groups.)

  • Submit your calculations and a 175-word summary of your conclusions.

Attachment:- Hypothesis testing .zip

Reference no: EM132637946

Questions Cloud

Conventional computer-aided manufacturing industry : The recent advances in information and communication technology (ICT) has promoted the evolution of conventional computer-aided manufacturing industry
Calculate the total revenue loss from the historical revenue : Calculate the total revenue loss in 2019 from the historical revenue (using historical number of seminars and total number of seminars in 2019)
Designing data communications network : How can a network designer determine if they are important, and how are they taken into account when designing a data communications network?
Explain the benefits of the potential fedex office solution : Explain a minimum of four benefits that the Global Training Associates will experience as a result of implementing the FedEx Office's solutions
Determine the average time in queue : Evaluate if the company should allocate more resources to improve its average TiQ. One of the most important metrics in a call center is Time in Queue
Explain what is exponential globalization : The second phase of overseas expansion. Why was this investment important? What type of information did Netflix derive from the data collected?
How would position the new product relative to pepsi : If you decided to introduce some form of new product, how would you position the new product relative to both Pepsi and any remaining Coke products?
What will the operating profit be : Assume that the projected number of units sold for the month is 5,500. What will the operating profit be
How much is the total assets as of December : The Script Co. had the following information for 20x1: Accounts receivable turnover 10:1. How much is the total assets as of December 31, 20x1

Reviews

Write a Review

Finance Basics Questions & Answers

  Compound and simple interest-pv-annuities

Illustrate compound interest formulas, using them to find future values and present values of the dollar; describe annuities and find out the future value or present value of annuity

  Should deep south buy the sound equipment

Should Deep South buy the sound equipment at this time? Why or why not?

  Find appropriate required rate of returnfor food products

What is an appropriate required rate of return (hurdle rate) for Food Products and Instruments? How did you get it?

  What is the value of a put option written on the stock

put-call parity the current price of a stock is 50 and the annual risk-free rate is 5.5. a call option with a strike

  Compute the cash received by southwest

Explain why Southwest does not recognize revenue when it receives the payment from its customers.

  Calculate the net interest margin

Calculate the net interest margin if the bank hedges its forward foreign exchange exposure? (Do not round intermediate calculations).

  How would you rank the bonds from the shortest to longest

consider the following bondsbond numbermaturity yrs coupon rate frequency yield annual11061621062631001641061559616how

  Have your spreadsheet be fully functional

Have your spreadsheet be fully functional? Have each worksheet be clearly labeled to identify the associated problem.

  What rate of growth must the firm experience

(Growth rate in stock dividends and the cost of equity) In March of this past year, Manchester Electric (an electrical supply company operating throughout.

  What will the bonds sell for today

Giant Electronics is issuing 20-year bonds that will pay coupons semiannually. The coupon rate on this bond is 7.8 percent. If the market rate for such bonds is 7 percent, what will the bonds sell for today?

  Evaluating the various health insurance plans

1. In evaluating the various health insurance plans, what factors should the Lawrences look for in a good health insurance plan? 2. When considering disability income insurance, what are the trade-offs of purchasing this type of insurance and how d..

  Calls for studying a reaction at low ph values

You are performing an experiment that calls for studying a reaction at low ph values. You need at least three different low ph values

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd