Answered step by step
Verified Expert Solution
Question
1 Approved Answer
About the data Invoices and Sales describe 2 datasets that should be cleaned and reconciled: total sales should equal total invoices, and the objective is
About the data Invoices and Sales describe 2 datasets that should be cleaned and reconciled: total sales should equal total invoices, and the objective is to identify and understand the differences Question 1: SALES AMOUNT and NET AMOUNT in Sales are both missing decimal points (i.e. row 2: 6850 should be 68.50 and 6000 should be 60.00). Update the raw data to correct for this decimal error TYPE in Sales indicates the sign of the transaction (positive or negative). 1 indicates a positive transaction and 2 indicates a negative transaction. Update the raw data to reflect the appropriate Answer 1a: After you have accounted for the missing decimal and sign, what is the total of the sales amount column? Answer and explain how you approached the problem in the Explanation + Summary tab. Answer 1b: After you have accounted for the missing decimal and sign, what is the total of the net amount column? Answer and explain how you approached the problem in the Explanation + Summary tab
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started