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

how to find data missing in a data set.
help on question how to find data missing in a data set.help on question I.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!