Construct a scatter diagram showing current balance

Assignment Help Applied Statistics

Reference no: EM133130047 , Length: 5 pages

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 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 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 (excel sheet for Regional Call Center is included):

• 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.

Attachment:- Transforming Data.rar

Reference no: EM133130047

Questions Cloud

Determine the effect on property values : In general, what effect would a reduction in risk have on going-in cap rates? What would this effect be if it occurred at the same time as an unexpected increas

Applied economics for applying it in our daily life : What is your idea about applied economics for applying it in our daily life?

Evaluate the actions of people in market from perspective : Consider a situation in which a natural disaster (like a hurricane) threatens to strike a costal region of the US. In preparation, many people go out to buy ply

Appreciation of the aud against the usd : Between 2010Q4-2013Q1 the Australian dollar's value reached parity, and also exceeded parity against the USD.

Construct a scatter diagram showing current balance : Construct a scatter diagram showing current balance on the horizontal axis and past due amount on the vertical axis

Find the change in social surplus : Suppose we have the following demand and supply functions (taken from Assignment #2).

Record the transactions in a general journal : Marienau Suppliers had the following transactions: Mar. 1 Sold merchandise on account to G. Perez, $5,200. Record the transactions in a general journal

Determine the depreciation charge : Determine the depreciation charge during the 6th year by Sinking Fund Method assuming 10.5% compounded annually.

Compute kelly and fishers price index numbers for 2021 : Construct the cost-of-living index number for 2020 on the basis of 2018 from the given data. Advice a donor agency on what course action to take if the informa

User Account

All Pages