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