Can you help me with this homework?

If yes, I need to email you the Excel file for data set.

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. Create 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? Create 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. Create a pie chart to illustrate the relative number of transfers in each location.

5. Create 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?

7. Create a column chart to illustrate the total number of deposits for the month in each

location.

8. Create 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. Create a chart for the time series of the total number of deposits by date.

10. Create a chart for the time series of the total deposit amount by date.

11. Create 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.)

For #12 - 24, consider only Withdrawal transactions.

12. Create 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. Create 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, create 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?

For #25 - 37, consider only Transfer transactions.

25. Create 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. Create 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, create 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?