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.
For #25 - 37, consider only Transfer transactions.
25. Show a histogram for the amount transferred.
26. What is the average amount transferred?
27. What is the median amount transferred?
28. What is the standard deviation of the amount transferred?
29. Compare the standard deviations of transfers and withdrawals, and talk about the differences in the distributions.
30. Show the five-number summary and draw the box and whiskers plot for the amount transferred.
31. Describe the distribution and general shape of the amount transferred.
32. Does the distribution look normal? Why or why not?
33. Are there any outliers? How many?
34. From this data, show a contingency table for transfers >= $500/under $500 in one dimension and location on the other.
35. What is the probability that a transfer is >= $500? (i.e. what proportion of all transfers is $500 or over?)
36. If a transfer is under $500, what is the probability that it originated in the drive-up location?
37. What is the probability that a transfer from Campus B is $500 or over?
38. Are location and size of transfer (over or equal to/under $500) independent events?
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