Question: how to find data missing in a data set. help on question I. Data Cleaning and Manipulation (10 points) There are five errors in the
I. Data Cleaning and Manipulation (10 points) There are five errors in the data set that must be identified and fixed. After finding the issues, list each error you fixed in a textbox included on a new worksheet named Errors Fixed. Also, highlight in yellow the cells in the original data set that contain the fixed data. (10 points) Sort the data by the Age of each employee - include a copy the sorted data on a new worksheet named Sorted Data. (10 points) Filter the original data to only include the employees that are "10" or higher units in the DistanceFromHome variable - include a copy of the filtered data on a new worksheet named Filtered Data. (10 points) Apply conditional formatting to turn the text red for in column B for each employee recorded as a "Yes" in the Attrition variable in the original data set
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
