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.

1. Describe the data, including how many total observations there are.

2. What do you think the field "time" means? How would you interpret it? show a visual (some sort of graph) with the variable time to test your hypothesis.

3. Include tables that count the number of observations by: a. Weekday b. Location c. Type of transaction

4. show a pie chart to illustrate the relative number of transfers in each location.

5. show a pie chart to illustrate the relative total transfer amount at each location.

6. Discuss the differences in the two pie charts. What do they tell you?