Homework
Case Study: Transforming Data into Information
Overview
You are a supervisor at Regional Call Center's Washington, DC, facility. Regional provides contract call center services for several 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 homework by the company CEO. The homework 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 and produce a report that would both graphically and numerically analyze the data. The data are for a sample of 57 calls and the following variables:
a) Account Number.
b) Past Due Amount.
c) Current Account Balance.
d) Nature of Call (Billing Question or Other).
Instructions
o Summarize the case scenario of the Regional Call Center's Washington, D.C. facility.
o Develop bar charts showing the mean and median current account balance.
o Construct a scatter diagram showing the current balance on the horizontal axis and the past due amount on the vertical axis.
o Compute the key descriptive statistics for the current and past due amounts.
o Repeat task 4 but compute the statistics for the past due balances.
o Compute the coefficient of variation for current account balances.
Write 4 to 5 pages 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.
Format your homework according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
The specific course learning outcome associated with this homework is:
o Apply strategies that are informed by the principles of statistical thinking and data-driven decision-making to enhance business process performance.