Hands on Assignment #$1$

$$ Please upload your answers as a Word document or a PDF document.

$$ Clearly label your answers and the graphs.

$$ Your full answer for each part should be contained in the submitted document. Do not

reference the spreadsheet. The answers such as "see spreadsheet" will not be accepted.

$$ Keep your Excel spreadsheet with all your work for your records. I may ask you to submit

your Excel spreadsheet separately. $($Be sure your work there is organized and easy to

follow.$)$

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

$($There should be three separate tables summarizing your data.$)$

$4.$ Create a pie chart to illustrate the relative number of transfers at 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 at each

location.

$8.$ Create a column chart to illustrate the total amount of deposits for the month at 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.$)$

Go on to the next page $->$

For #$1223,$ 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. Does the

distribution look normal? Why or why not?

$18.$ Are there any outliers? How many? $($List or describe outliers, if any. Be sure to use the

$1\mathrm{.}5$IQR rule for outliers$).$

$19.$ From this data, create a contingency table for withdrawals under $$50/=$ $$50/$over $$50$ in

one dimension, and location on the other.

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

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

location?

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

$23.$ Are location and size of withdrawal $(>50,=50,<50)$ independent events? $($Be sure to use

the rule for independent events to support your reasoning. Simply saying $$Yes$$ or $$No$$

will not earn you any points.$)$

Go on to the next page $->$

For #$2436,$ consider only Transfer transactions.

$24.$ Create a histogram for the amount transferred.

$25.$ What is the average amount transferred?

$26.$ What is the median amount transferred?

$27.$ What is the standard deviation of the amount transferred?

$28.$ Compare the standard deviations of transfers and withdrawals, and talk about the

differences in the distributions.

$29.$ Create the five$-$number summary and draw the box and whiskers plot for the amount

transferred.

$30.$ Describe the distribution and general shape of the amount transferred. Does the

distribution look normal? Why or why not?

$31.$ Are there any outliers? How many? $($List or describe outliers, if any. Be sure to use the

$1\mathrm{.}5$IQR rule for outliers$).$

$32.$ From this data, create a contingency table for transfers $>=$ $$500/$under $$500$ in one

dimension and location on the other.

$33.$ What is the probability that a transfer is $>=$ $$500?($i$.$e$.$ what proportion of all transfers is

$$500$ or over?$)$

$34.$ If a transfer is under $$500,$ what is the probability that it originated in the drive$-$up

location?

$35.$ What is the probability that a transfer is $$500$ or over if it is from Campus B$?$

$36.$ Are location and size of transfer $($over or equal to$/$under $$500)$ independent events? $($Be

sure to use the rule for independent events to support your reasoning. Simply saying $$Yes$$

or $$No$$ will not earn you any points.$)$