Posted: December 16th, 2022

Bba 301 – week 2 data validation assignment

The HR tab in Hospital.xlsx file contains the employee records downloaded from the personnel database of a fictitious hospital.  Data is required in all fields except Address 2 and Phone. If a phone number is entered it must adhere to the 999-999-9999 format.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

At least 100 data errors exist in this file.

On the Errors tab in Hospital.xlsx file, document each error by identifying the location of the error (ID Number), the type of error (omission, range, data entry, etc.), and the correct information, if known. You receive one point for each VALID error identified. Truncation of data to the maximum number of characters for a field is NOT considered an error as it is imposed by the system and not a data entry error. Extra credit is available for deeper analysis.

An additional file name Zipcode.xlsx is available as a reference.  

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
error: Content is protected !!
Open chat
1
Order through WhatsApp!
professionalsessays.com
Hello!
You Can Now Place your Order through WhatsApp
 

 

Order your essay today and save 30% with the discount code 2022DISCOUNT