Please submit your assignment via Blackboard, as a single Word file.

1.The Eagle County Motor Vehicle Bureau (ECMVB) gives each customer a survey after completing their transaction.The customer is asked to provide a rating from one to five, where one indicates poor ECMVB performance, and five indicates excellent ECMVB performance.Yesterday's survey results are shown in the Excel file "SurveyResponses."The survey was given to nine hundred twenty two people.Many of the entries are blank, indicating that the customer declined to provide a rating.The ECMVB director would like to do some basic descriptive analytics on this data set.How should she handle the blank entries, and why?(Suggested answer length: maximum a hundred words)

2.Import the data in the "Deposits" Excel file into RapidMiner.It consists of all individual deposits made at a regional bank in a single day.There are three thousand five hundred ten 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.

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

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