1. Import the data in the "Deposits
2. Download Deposits
3. " Excel file into RapidMiner. It consists of all individual deposits made at a regional bank in a single day.There are 3510 deposits, and four attributes (columns) in the data set: the deposit amount; whether the customer was depositing cash, checks, or both; the branch number; and whether the transaction was handled by an ATM or a teller.

As the analyst working on the data set, you have determined that Branch # is irrelevant.You have also noticed that there are several "-1" values for the Amount ($) variable, which indicate an error in processing the deposit.You plan to focus primarily on cash deposits.

1. a) Build a process in RapidMiner that does the following:

-Selects the Amount ($), Type, and Method attributes (but not Branch #)

-Removes all rows from the data set with Amount ($) = -1

-Keeps only rows with Type = "Cash"

Show a screenshot of the Process panel.(You do not need to include the Parameters panel.)

1. b) Run your process from part a. Show a screenshot of the Statistics output in the Results view, with Amount ($) expanded (that is, with the histogram and deviation visible for the Amount ($) attribute).