Please read! Hints and tips!
Part 1. C. - Delete the duplicate record and 2016 invoice date record. (Keep one transaction for each of the transaction number).
There are Transaction Numbers in the Data set that are 2016 Invoices but they are the only one transaction for the transaction Number. Should I delete because it is 2016? or Keep because it is the only one for that Transaction number?
Yes! Please drop 2016 data and duplicated data.
Part 2. C. Summarize the total dollar amount by each of the customers. (5 points)
There is not a column in the table for this value. - I can add a column if this is what you advise.
Yes! Please add a column for the total amount.
Part 2. F. If the total dollar amount of the orders for the customers used UPS Trade Direct is larger than the other two methods. Otherwise, put “yes” into M column. Otherwise, put “no” into the column.
The total Dollar amount is higher than the other two methods... Combined? or individually?
Individually. The total
dollar is higher than both of the other two methods.
Last modified: Monday, September 7, 2020, 9:03 AM