1. Excel: Drag in the Absences worksheet into the Employee Database workbook. Use a VLOOKUP to copy over the unplanned absences by employee into column P. 2. Calculate the daily absentee wage (see note 1) by employee in column Q in the Employee Data worksheet. (Annual salary/No of working days in a year) 3. Calculate the yearly cost of absenteeism by employee in column R in the Employee Data worksheet. (days absent* daily salary) 4. Bring in the absence code by employee into Column S from the Employee Absenteeism Causes workbook using a VLOOKUP. 5. Use this Employees Database for Outliers workbook to calculate the outliers in Rapidminer. 6. RAPIDMINER: a. In the Process pane, drag the Excel Employee Database for Outliers sheet you just built in Excel into the Process pane. b. Rapidminer will ask you which worksheet (Employee Data) to use, which columns (A-5), and the rest of questions are defaults. On the Where to Store the Data? Choose your Local DATA Repository as the location. C. Go back to Design mode, and drag the just saved file into the Rapidminer process