Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

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...

Q:

Dataset and task description Describe the data analytics task for the chosen dataset. How does the dataset used to solve a business problem? Show the dataset characteristics, namely the number of...

Q:

Can someone help me with the following questions? Chosen dataset: Auto-mpg, can be found on kaggle Answer each of the following sections based on Auto-mpg dataset Dataset and task description [5%]...

Q:

Need help 6-8 6. Consider the following data set of number of baskets out of ten that 32 people made at the free throw line: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 3, 3, 3, 3, 3, 3, 4, 5, 5,...

Q:

6. Consider the following data set of number of baskets out of ten that 32 people made at the free throw line: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 3 , 3, 3, 3, 3 , 3 , 4, 5, 5, 6, 7, 7,...

Q:

MAT150.5 Statistics Online Course Assignment #3 1. Make a frequency distribution for the following data of inches of rainfall in Brooklyn per year, using 6 classes. 60 105 95 80 90 100 75 70 84 98...

Q:

Descriptive statistics [40%] 2.1. Categorical variables [20%] 2.1.1. Consider each of the categorical variables and create a frequency table including frequency, relative frequency, cumulative...

Q:

2. Descriptive statistics [50%] 2.1. Categorical variables [20%] 2.1.1. Consider one categorical variable and create a frequency table including frequency, relative frequency, cumulative frequency...

Q:

MAT150.5 Statistics Online Course Assignment #3 1. Make a frequency distribution for the following data of inches of rainfall in Brooklyn per year, using 6 classes. 60 105 95 80 90 100 75 70 84 98...

Q:

MTH 105 Data Collection and Analysis Project In this project you will be collecting and analyzing data in effort to determine an answer to the following research question: Do younger adults in the US...

Q:

Assignment Questions Determine the friction force on the crate of mass M, and the resultant normal force and its position x, measured from point A, if the force is P. Given: M = 40 kg Hs = 0.5 a =...

Q:

Read the article America is giving away $30 Billion Medical marijuana industry and summarize it?

Q:

Write the next three terms of the geometric sequence. - 3 7 5 , - 7 5 , - 1 5 , - 3

Q:

Sarah's Organic Soap Company makes organic liquid soap. One of the raw materials for her soaps is organic palm oil. She needs 1,000 kg of palm oil per day on average. The supplier charges a $67...

Q:

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...

Q:

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...

Q:

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...