Use the data in the Excel file Errors to create a frequency table, then fill in the
Fantastic news! We've Found the answer you've been seeking!
Question:
Use the data in the Excel file "Errors" to create a frequency table, then fill in the values for relative frequency of each class.
What does this frequency table tell you, from the managerial perspective, about the most and the least common sources of errors? Which errors would you prioritize resolving, as a manager, if the cost of addressing each type of error is roughly the same?
Combine your table and explanation into one PDF file and upload it here.
| Type of Error on Billing Statement |
| Incorrect Items Billed |
| Missing Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Missing Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Wrong Customer Billed |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Wrong Customer Billed |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Phone Number |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Missing Address |
| Past Payment Not Recorded |
| Missing Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Items Billed |
| Missing Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Phone Number |
| Missing Phone Number |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Missing Phone Number |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Phone Number |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Missing Phone Number |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Phone Number |
| Past Payment Not Recorded |
| Missing Phone Number |
| Past Payment Not Recorded |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Address |
| Missing Phone Number |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Missing Address |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Missing Phone Number |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Wrong Customer Billed |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Missing Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Missing Phone Number |
| Missing Phone Number |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Address |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Missing Phone Number |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Address |
| Missing Phone Number |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Address |
| Incorrect Address |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Missing Phone Number |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Missing Phone Number |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Missing Address |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Wrong Customer Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Address |
| Past Payment Not Recorded |
| Missing Phone Number |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Missing Phone Number |
| Wrong Customer Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Address |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Missing Phone Number |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Incorrect Address |
| Missing Phone Number |
| Incorrect Items Billed |
| Missing Address |
| Incorrect Items Billed |
| Missing Phone Number |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Address |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Incorrect Address |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Address |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Wrong Customer Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Missing Address |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Past Payment Not Recorded |
| Incorrect Items Billed |
| Past Payment Not Recorded |
| Incorrect Items Billed |
Expert Answer:
Posted Date:
