Regional. The CEO had asked you to describe the data in a file called Regional C

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
Summarize the case scenario of the Regional Call Center’s Washington, D.C. facility.
Develop bar charts showing the mean and median current account balance.
Construct a scatter diagram showing current balance on the horizontal axis and past due amount on the vertical axis.
Compute the key descriptive statistics for current and past due amount.
Repeat task 4 but compute the statistics for the past due balances.
Compute the coefficient of variation for current account balances.
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.
This course requires the use of Strayer Writing Standards (SWS). The library is your home for SWS assistance, including citations and formatting. Please refer to the Library site for all support.
The specific course learning outcome associated with this assignment is:
Apply strategies that are informed by the principles of statistical thinking and data-driven decision-making to enhance business process performance.
Week 4 Assignment – Case Study: Transforming Data Into Information
Week 4 Assignment – Case Study: Transforming Data Into Information
Criteria Ratings Pts
Summarize the case scenario including relevant tasks. (10%)
view longer description
11 to >9.89 pts
Exemplary
Summarizes the case scenario including relevant tasks.
9.89 to >8.79 pts
Competent
Describes the case scenario but missing some tasks.
8.79 to >7.69 pts
Needs Improvement
Describes the case scenario without relevant tasks.
7.69 to >0 pts
Unacceptable
Does not summarize the case scenario including relevant tasks.
/ 11 pts
Develop bar charts showing the mean and median current account balance. (15%)
view longer description
16.5 to >14.84 pts
Exemplary
Develops bar charts for mean and median current balance account.
14.84 to >13.19 pts
Competent
Presents bar charts for either the mean or median for current account balance.
13.19 to >11.54 pts
Needs Improvement
Presents inaccurate bar charts for either the mean or median for current balance account.
11.54 to >0 pts
Unacceptable
Does not develop bar charts showing the mean and median current account balance.
/ 16.5 pts
Construct a scatter diagram showing current balance and past due amount on the correct axis. (15%)
view longer description
16.5 to >14.84 pts
Exemplary
Constructs a scatter diagram showing current balance and past due amount on the correct axis.
14.84 to >13.19 pts
Competent
Produces the scatter plot for both current balance and past due amount values, but with the wrong axis.
13.19 to >11.54 pts
Needs Improvement
Produces inaccurately the scatter plot for both current balance and past due amount.
11.54 to >0 pts
Unacceptable
Does not construct a scatter diagram showing the current balance and past due amount on the correct axis.
/ 16.5 pts
Compute key descriptive statistics for current and past due amount. (10%)
view longer description
11 to >9.89 pts
Exemplary
Computes key descriptive statistics for current and past due amount.
9.89 to >8.79 pts
Competent
Determines some descriptive statistics for current and past due amount.
8.79 to >7.69 pts
Needs Improvement
Calculates inaccurately key descriptive statistics for current and past due amount.s.
7.69 to >0 pts
Unacceptable
Does not compute key descriptive statistics for current and past due amount.
/ 11 pts
Compute key descriptive statistics for the past due balance. (10%)
view longer description
11 to >9.89 pts
Exemplary
Computes key descriptive statistics for the past due balance.
9.89 to >8.79 pts
Competent
Determines some descriptive statistics for the past due balance.
8.79 to >7.69 pts
Needs Improvement
Calculates inaccurately key descriptive statistics for the past due balance.
7.69 to >0 pts
Unacceptable
Does not compute key descriptive statistics for the past due balance.
/ 11 pts
Compute the coefficient of variation for current account balances. (10%)
view longer description
11 to >9.89 pts
Exemplary
Computes the coefficient of variation for current account balances.
9.89 to >8.79 pts
Competent
Determines the coefficient of variation with error for the current account balances.
8.79 to >7.69 pts
Needs Improvement
Calculates the coefficient of variation using the incorrect account balance.
7.69 to >0 pts
Unacceptable
Does not compute the coefficient of variation for current account balances
/ 11 pts
Generate analysis of the descriptive statistics, coefficient of variation, and graphs. (10%)
view longer description
11 to >9.89 pts
Exemplary
Generates analysis of the descriptive statistics, coefficient of variation, and graphs.
9.89 to >8.79 pts
Competent
Generates appropriate analysis of the descriptive statistics or coefficient of variation, or graphs.
8.79 to >7.69 pts
Needs Improvement
Generates inappropriate analysis of the descriptive statistics, coefficient of variation, and graphs.
7.69 to >0 pts
Unacceptable
Does not generate analysis of the descriptive statistics, coefficient of variation, and graphs.
/ 11 pts
Recommend, based on data analysis and graphs, two strategies to improve the service to the client. (10%)
view longer description
11 to >9.89 pts
Exemplary
Recommends, based on data analysis and graphs, two strategies to improve the service to the client.
9.89 to >8.79 pts
Competent
Recommends, based on incorrect data analysis, two strategies to improve the service to the client.
8.79 to >7.69 pts
Needs Improvement
Recommends, without data analysis, two strategies to improve the service to the client.
7.69 to >0 pts
Unacceptable
Does not recommend, based on data analysis and graphs, two strategies to improve the service to the client.
/ 11 pts
Provide two quality resources. (5%)
view longer description
5.5 to >4.94 pts
Exemplary
Meets the required number of references; all references are peer-reviewed, academic references.
4.94 to >4.39 pts
Competent
Meets the required number of references; some or all references are not peer-reviewed, academic references.
4.39 to >3.84 pts
Needs Improvement
Does not meet the required number of references; some or all references are not peer-reviewed, academic references.
3.84 to >0 pts
Unacceptable
No references provided.
/ 5.5 pts
Writing contains accurate grammar, mechanics, and spelling in accordance with SWS style. (5%)
view longer description
5.5 to >4.94 pts
Exemplary
Writing contains no grammar, mechanical, and/or spelling errors.
4.94 to >4.39 pts
Competent
Writing contains 1–2 grammar, mechanical, and/or spelling errors.
4.39 to >3.84 pts
Needs Improvement
Writing contains 3–5 grammar, mechanical, and/or spelling errors.
3.84 to >0 pts
Unacceptable
Writing contains excessive grammar, mechanical, or spelling errors that impede the reading of the assignment.
/ 5.5 pts