Reference no: EM131118425
The Complaint Spreadsheet shows performance measures; specifically complaints. The data needs to be run for 2016 creating a reporting table and graph to post to your team's huddle board. Consider the following information when analyzing the table:
The initiated date and completed date is the time between the initiation of the complaint and the time it takes to complete the complaint.
There are 3 options for outcomes: 1. Non-regulator; 2. Substantiated; 3. Not substantiated---be aware, an incomplete means there is no data.
Disregard the submitted data-you will need to hide this element in the spreadsheet.
The complaint against=the licensed entity the complaint originated against.
Using this spreadsheet and the above information, perform the following:
1. Fix any errors in calculations or formulas, should there be any.
2. Provide analysis for 2 quarters-1. January-March 2016; 2. April-June 2016-how many complaints are there for each quarter-provide 2 colorful graphs showing the actual number as well as the percentages
3. Provide analysis for 2 quarters-1. January-March 2016; 2. April-June 2016-what is the average number of days from initiated to completed (include all)-provide 2 colorful graphs showing the number of calendar days
4. Analyze how many complaints were received each month and the number of days it took to complete-provide a chart illustrating this
5. Document the steps you took to complete this work and make any conclusions or recommendations.
Attachment:- Assignment.rar
|
Running for president of your condominium association
: You are running for president of your condominium association. As part of your campaign, you are preparing a speech to the residents. State a proposition for what your audience should gain from your speech. A specific pattern you will use for arrangi..
|
|
Stage of development of an economy improves
: Explain how and why distribution channels are affected as they are when the stage of development of an economy improves. Give an example of a country where this situation has occurred.
|
|
What is standard deviation of the project completion time
: What is the standard deviation of the project completion time for the case study?(global text book publishers)? What is the probability of completing the project in 118 days?
|
|
When managing employee diversity in organizations
: Within your post, support your responses with information from at least one peer-reviewed/scholarly source (not older than 3-5 years) from CSU Global online library or the Internet, and provide the full citation at the end. What are some challenges l..
|
|
What is the average number of days
: Provide analysis for 2 quarters-1. January-March 2016; 2. April-June 2016-what is the average number of days from initiated to completed (include all)-provide 2 colorful graphs showing the number of calendar days
|
|
How much would be added to management reserve for this risk
: Research what is meant by factored cost as it relates to probability X impact and establishing a management reserve. Provide an example for your classmates of an identified risk and the probability X impact. How much would be added to management rese..
|
|
How did focus groups originate
: How did focus groups originate? According to Luker, how do you know when you have gathered enough data and can begin analyzing your data?
|
|
Building blocks to information literacy
: Communication and Critical Thinking - Building Blocks to information Literacy. Then explain how information literacy is a set of skills that builds or relies upon an expansion of communication and critical thinking skills. In other words, why are com..
|
|
Examine the psychometric properties
: MGMT 571 Measurement Theory and Method Final Take-Home Test Fall 2016. You are provided two data-sets, one from male and the second from female (coded as gender=1 & 2 respectively) managers-that are collected to examine the psychometric properties
|