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.

For #12 - 24, consider only Withdrawal transactions.

12. Show a histogram for the amount withdrawn.

13. What is the average amount withdrawn?

14. What is the median amount withdrawn?

15. What is the standard deviation of the amount withdrawn?

16. Show the five-number summary and draw the box and whiskers plot for the amount withdrawn.

17. Describe the distribution and general shape of the amount withdrawn.

18. Does the distribution look normal? Why or why not?

19. Are there any outliers? How many?

20. From this data, show a contingency table for withdrawals under $50 / = $50 /over $50 in one dimension, and location on the other.

21. What is the probability that a withdrawal is >= $50?

22. If a withdrawal is over $50, what is the probability that it originated in the drive-up location?

23. What is the probability that a withdrawal from Campus A is greater than $50?

24. Are location and size of withdrawal (>50, =50, <50) independent events?