Chat with us, powered by LiveChat You are a supervisor at Regional Call Center’s Washington, DC, facility. Regional provides contract call center services for a number of companies, including banks and major retail - Writeden

 Overview

You are a supervisor at Regional Call Center's Washington, DC, facility. Regional provides contract call center services for a number of companies, including banks and major retail companies. You have been with the company for slightly more than seven years, having joined Regional right after graduating with a master's degree in business administration from Strayer University. After the monthly staff meeting, you were handed a new assignment by the company CEO. The assignment came out of a discussion at the meeting in which one of Regional's clients wanted a report describing the calls being handled for them by Regional. The CEO had asked you to describe the data in a file called Regional Call Center Download Regional Call Center and produce a report that would both graphically and numerically analyze the data. The data are for a sample of 57 calls and for the following variables:

  • Account Number.
  • Past Due Amount.
  • Current Account Balance.
  • Nature of Call (Billing Question or Other).

Instructions

  1. Summarize the case scenario of the Regional Call Center's Washington, D.C. facility.
  2. Develop bar charts showing the mean and median current account balance.
  3. Construct a scatter diagram showing current balance on the horizontal axis and past due amount on the vertical axis.
  4. Compute the key descriptive statistics for current and past due amount.
  5. Repeat task 4 but compute the statistics for the past due balances.
  6. Compute the coefficient of variation for current account balances.
  7. Write a 4-5 page report (including a cover page and a source list page) to National's client that contains the results of the completed tasks along with a discussion of the statistics and graphs.

Sheet1

Account Number Past Due Amount Current Amount Due Was this a Billing Question?
4348291 35 92.85 Yes
6008516 20 -129.67 No
17476479 0 86.38 No
13846306 35 99.24 No
21393711 0 47.98 Yes
18712654 22 40.89 Yes
19432077 0 -93.16 No
19205946 0 85.21 Yes
8679852 0 121.79 No
12762185 0 0 No
4139796 386.77 0 Yes
17139670 0 102.03 No
8979191 88.36 150.84 Yes
7280135 0 54.57 Yes
6707912 0 0 No
21520203 0 46.98 No
85623 0 78.41 Yes
9356536 0 142.95 Yes
17405616 0 51.83 Yes
20898785 155.8 217.86 Yes
19731969 0 26.08 No
12784685 90.7 181.67 Yes
20085243 0 1.12 Yes
20795784 0 -18.13 No
7487786 0 2.13 No
10728849 0 0 No
8688412 70.89 116.54 Yes
16719086 0 0 No
21133695 50.26 82.65 Yes
161458 0 58.82 No
15633571 0 57.54 Yes
5237633 0 27.03 No
16519689 0 41.99 Yes
16913865 0 -60.98 Yes
9862516 0 0 No
1086650 0 52.49 No
3294331 0 58.16 No
21119372 59.83 135.41 Yes
13763582 0 50.79 No
1594961 0 108.08 No
9602244 0 99.48 No
18848188 184.49 184.49 Yes
18538915 0 71.75 Yes
11844400 0 0 No
21422890 51.63 151.92 Yes
19069405 0 168.71 No
12008703 0 4.62 Yes
10986262 0 65.93 No
15042777 0 53.97 No
14501019 0 59.07 No
7071682 0 323.78 No
4567183 29.75 144.48 No
17862401 0 0 Yes
19301485 0 0 No
11169789 0 0 Yes
9377520 50.64 58.55 Yes
19753827 33.83 68.68 Yes