Work the following problems. Full datasets for the problems are provided in the attached Excel file....

 

Transcribed Image Text:

Work the following problems. Full datasets for the problems are provided in the attached Excel file. For each problem, you may work the problem completely by hand or use appropriate software. If you do the work by hand, your charts and/or diagrams should be neat and legible. Setup for Problems 1 and 2: A company that manufactures a field instrument used by geologists keeps track of units that are returned for repairs. Each returned unit is assigned a Return Material Authorization (RMA) number. For each RMA, the RMA date and reason for return is recorded. For 2021, a total of 55 RMAS were issued. The data for these RMAS is provided in the RMA Data tab of the Excel file. The data look like this (abbreviated table shown): RMA Date RMA Number 2021-0001 2021-0002 01/08/21 Damaged port RMA Reason Damaged port 01/05/21 2021-0003 01/12/21 Other 2021-0004 01/12/21 Physical damage 1 2021-0052 12/08/21 Physical damage 2021-0053 12/16/21 Display 2021-0054 12/22/21 Power supply 2021-0055 12/28/21 Display Work the following problems. Full datasets for the problems are provided in the attached Excel file. For each problem, you may work the problem completely by hand or use appropriate software. If you do the work by hand, your charts and/or diagrams should be neat and legible. Setup for Problems 1 and 2: A company that manufactures a field instrument used by geologists keeps track of units that are returned for repairs. Each returned unit is assigned a Return Material Authorization (RMA) number. For each RMA, the RMA date and reason for return is recorded. For 2021, a total of 55 RMAS were issued. The data for these RMAS is provided in the RMA Data tab of the Excel file. The data look like this (abbreviated table shown): RMA Date RMA Number 2021-0001 2021-0002 01/08/21 Damaged port RMA Reason Damaged port 01/05/21 2021-0003 01/12/21 Other 2021-0004 01/12/21 Physical damage 1 2021-0052 12/08/21 Physical damage 2021-0053 12/16/21 Display 2021-0054 12/22/21 Power supply 2021-0055 12/28/21 Display

Answer rating: 100% (QA)

For this we can make the following I have created the pivot with the data You ... View the full answer