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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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