This assignment provides you an opportunity to utilize the functions and tools of Excel to solve a basic analytics scenario: data validation.The purpose of this assignment is to use Excel to quickly identify the possible errors within the database, and not tovisually examine all6,000+ database records.

The HR tab inHospital.xlsxfile contains the employee records downloaded from the Human Resource database of a fictitious hospital. As with any acquired data, you must be aware of the limitations of your dataset.

The sourcing database for Hospital.xlsx has a limit of twenty (20) characters for the Address 1 and Address 2 fields.Therefore, truncated addresses are not considered errors. The only errors in the Address fields that can be easily identified in Excel would be a missing address or an address of insufficient length to contain a deliverable address. Six characters is the minimum length for an address (e.g. "1 U St".)