Question
The ATM Transactions Excel Workbook contains a data set of Credit union transactions for 30 days at a drive-up ATM and two walk-up ATMs on-campus
The "ATM Transactions" Excel Workbook contains a data set of Credit union transactions for 30 days at a drive-up ATM and two walk-up ATMs on-campus in student union buildings at two different university campuses. Show a comprehensive data analysis report that addresses the following questions. Please make sure that all of your visualizations have proper labels, titles, axis titles, and that they follow general guidelines of creating good data visualization.
7.Show a column chart to illustrate the total number of deposits for the month in each location.
8. Show a column chart to illustrate the total amount of deposits for the month in each location.
9. This data contains 30 days of transactions, with the "date" variable indicating the date of the transaction. Show a chart for the time series of the total number of deposits by date. 10. Show a chart for the time series of the total deposit amount by date.
11. Show a chart that illustrates the time series of the total amount of withdrawals by date for each location. (There should be 3 lines on this chart, since there are 3 ATM locations.)
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