FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the data in the Excel file Errors I need to create a frequency table and then fill in the values for relative frequency of

Using the data in the Excel file "Errors" I need to create a frequency table and 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? The Excel file errors contains:

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Geometry, Its Elements And Structure

Geometry, Its Elements And Structure

Authors: Alfred S Posamentier, Robert L Bannister

2nd Edition

0486782166, 9780486782164

More Books

Students also viewed these Mathematics questions

Question

★★★★★
You have just heard on the news that there was a major data breach at your university and that personal identification information of all students, faculty, and employees may have been compromised....

Answered: 1 week ago

Question

★★★★★
In Problems 1 through 28, determine whether or not the given matrix A is diagonalizable. If it is, find a diagonalizing matrix P and a diagonal matrix D such that P -1 AP = D. 6-10 2 -3

Answered: 1 week ago

Question

★★★★★
For the random variable X, it is known that E(X4) = 50, E(2X2 + 7) = 17. Then the variance of the variable Y = X2 equals (a) 25 (b) 50 (c) 75 (d) 94 (e) 100

Answered: 1 week ago

Question

★★★★★
As the controller of Breathless Perfume Company, you discover a misstatement that overstated net income in the prior years financial statements. The misleading financial statements appear in the...

Answered: 1 week ago

Question

★★★★★
amorite leader of babylon,famous for his law code

Answered: 1 week ago

Question

★★★★★
Gavin Mills has an existing facility that it paid 29,000,000 for 10 years ago. It has 3 choices for this facility now: a. sell it outright for 9.5M today, b. lease it for the next 4 years to a...

Answered: 1 week ago

Question

★★★★★
What is the positive number with the largest magnitude that can be represented with 6 bits in Twos Complement form? State the answer in both binary and decimal formats.

Answered: 1 week ago

Question

★★★★★
Meeting privately with Carl and Amy, Daniel told each of them, "I understand how strongly you feel about this situation both the light rail itself and the other issues that it brings up for you about...

Answered: 1 week ago

Question

★★★★★
Describe a time when a message you sent was misunderstood or failed to engage the intended audience. Next, use the module resources or other outside sources to locate two strategies for reaching...

Answered: 1 week ago

Question

★★★★★
Now that you have learned about the murders of Gwen and Lawrence, answer the following questions. To what degree might an explanation of Gwen's murder lie in the "psychological functions" served by...

Answered: 1 week ago

Question

★★★★★
psychodynamic therapy with children principles emphasizes following the child this thought principle guides the therapy structure in all the following ways except: A. length is based on childs...

Answered: 1 week ago

Question

★★★★★
What are the challenges faced by workers all across the world as suburbanization expands and the distance traveled to the workplace increases? Can this be addressed through telecommuting and a more...

Answered: 1 week ago

Question

★★★★★
Please help Consider the function f (x) = 3x - x2. Use the limit definition to compute the following derivative values: f' (0 ) = f'(1) = f' ( 2 ) = f' (3) = Conjecture a formula for f'(a) that...

Answered: 1 week ago

Question

★★★★★
Reporting to the SEC Bruse Company common shares are listed on the American Stock Exchange and are actively traded. In a recent article in one of the financial publications, you read about a number...

Answered: 1 week ago

Question

★★★★★
Budget Analysis New England Ski Products recently established goals that it hopes to achieve with regard to asset and debt management. A summarized balance sheet and budgeted percentages at year-end...

Answered: 1 week ago

Question

★★★★★
Developing Financial Ratios You have obtained the financial statements of A-Tec and Bi-Sci, new companies in the high-tech industry. Both companies have just completed their second year of...

Answered: 1 week ago

Previous Question Next Question