Question: The provided data contains only static values, not underlying calculations. Create a new column to calculate and verify transaction amount. Note any discrepancies. 5 .

The provided data contains only static values, not underlying calculations. Create a new column
to calculate and verify transaction amount. Note any discrepancies.
5. Run descriptive analytics on the transaction amount. Report your findings using a screenshot
and describe any results not conforming to expectations.2
6. Test for any duplicates or gaps in the transaction numbers. Specify what function(s) you utilized,
your findings, and any concerns.
7. Calculate the following metrics. Report each finding using a screenshot of your findings in their
tabular format or as a graph. Be sure to show AT LEAST 3 different types of visualizations to
support your findings (table, bar graph, pie graph for example). Ensure all visualizations are
labeled and titled appropriately.

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 Databases Questions!